Microsoft Access 2003 Security
There are a couple of ways that you can add user-level security to a database in Access 2003. The first is by using the User-Level Security Wizard. To use the security wizard, open the database to which you want to add protection. Go to the Tools menu, select Security and click on User-Level Security Wizard. Follow the steps in the wizard to secure the database at a user level.
Using the User-Level Security Wizard also creates a backup copy of the database as an added measure of protection. If you create passwords via the wizard they will be included in the report that is available to print when the wizard is complete. Be sure to keep this report in a secure location.
If you want to protect certain objects in a database but don't need different levels of permission, you can protect the database, grant permissions to only the objects you choose and then turn off the Logon dialog box. All users will automatically be logged in as Admin users in the Users group and the permissions will already be specified.
To do so, begin by using the User-Level Security Wizard to protect the database. Then, go to the Tools menu, point to Security and select User and Group Permissions. Go to the Permissions tab of the dialog box. Click Users or Groups and select the user or the group to whom you want to assign permissions. Select the type of object you want to protect in the Object Type box. Click the name of the object for which you want to assign permissions. If you want to select several obects, press and hold the Ctrl key while you select each one. Select the permissions you want to assign and click Apply.
To turn off the Logon dialog, join the workgroup for which you want to deactivate it. To do so, go to the Tools menu, point to Security and select Workgroup Administrator. Click Join, enter the workgroup information and click OK. Go back to the Tools menu, point to Security and select User and Group Accounts. Go to the Users tab. Select Admin in the Name box and click Clear Password.