Microsoft Office Tutorials and References
In Depth Information
Controlling What Happens When You Open the Database
Be sure that you set a Windows password. If the database lives in a shared
folder on a local area network (LAN), check with your LAN administrator to
make sure that only the right people have access to the shared folder. Part
of security is making sure that no one walks off with your database — such
as copying it and taking it offsite — or deletes it! That’s why Windows-level
and LAN-level security are important.
For information about networking and Windows security, see Networking
For Dummies, 9th Edition, by Doug Lowe; or see Windows 7 For Dummies,
Windows Vista For Dummies, or Windows XP For Dummies, all by Andy
Rathbone (John Wiley & Sons, Inc.).
Controlling What Happens When
You Open the Database
If you don’t want users entering data (except in the forms you create);
modifying your tables, queries, forms, and other database objects; and generally
screwing up your lovely Access system, you can prevent them from using —
or even seeing — Design view and Layout view in Access. You can set the
startup options to control what the database user can see and do.
Click the File tab on the Ribbon, choose Options to display the Access
Options dialog box, and select Current Database (see Figure 3-1). The
settings in the dialog box apply to the current database. If you change them,
many don’t take effect until you exit and reopen the database.
page of the