Microsoft Office Tutorials and References
In Depth Information
Using the Trust Center
Granting database access to specific users
Access 2003 and earlier versions had a system
of user-level security in which you could create
users and groups of users and then grant them
specific permissions. When each user opened
the database, he or she typed a username and
password, so Access always knew who was
using the database and allowed or disallowed
commands accordingly. This system still works
with old-format ( .mdb ) database files.
This system was confusing, hard to set up, and
not hard to break into, however, so Microsoft
abandoned it in Access 2007. Access 2013
can still open an .mdb file that has user-level
security, if you have the necessary permissions
and password, but you can’t set up or change
this type of security for use with .accdb files.
If you want to apply different security
settings to different users, you should use a
more secure back-end database (such as SQL
Server or MySQL) to store your tables and give
each user an account on that database with
appropriate permissions. When you link to
each table from Access, you enter the user’s
username and password, which prevents that
user from viewing or editing tables for which
he or she doesn’t have permission. (Book IX,
Chapter 2 describes how to use Access to link
to SQL Server.)
For a detailed, if slightly out-of-date, write-up
on Access user-level security, see http://
assistance/HA011381161033.aspx .
If you’re going to perform this procedure often, consider splitting your table
into a front end and a back end, as described in Chapter 2 of this minibook.
With a split database, you don’t have to import your updated tables again;
you can just leave them in the unchanged back-end database.
Using the Trust Center
Access 2013 handles many of its security settings in one dialog box: the
Trust Center. One feature is that Access wants to know whether you trust the
database because you trust the folder where it’s stored, you trust the
publisher who created and signed the database, or you just trust this specific
database. If you trust a database, you can use the macros and VBA modules
in the database. Book VI, Chapter 1 describes the settings that determine
how to tell Access that you trust a database.
The Trust Center has a few other settings that affect the security of the
database and your computer. To see the Trust Center dialog box, click the File
tab on the Ribbon, choose Options to open the Access Options dialog box,
select Trust Center in the left pane, and then click the Trust Center Settings
button. Figure 3-3 shows one page of the Trust Center dialog box.
Search JabSto ::

Custom Search