Turn off the Logon dialog box

If you don't need to establish different levels of permissions for different groups of users, you can have Microsoft Access automatically log users on as the Admin user in the Users group with the permissions specified for that group. Users will not be required to enter their user name and password in the Logon dialog box when they open the database. Using this method, you can secure any or all of the objects in a database. However, each user will have the same set of permissions. This does not remove user-level security from the database.

1. Join the workgroup that has the logon procedure that you want to deactivate.

   How?

   Important   If you are setting up user-level security and need to make sure that your workgroup and its permissions can't be duplicated, you should make sure the workgroup information file that defines the workgroup you're joining has been created with a unique workgroup ID (WID). If such a workgroup information file doesn't exist, you should create one.

   1. Start Microsoft Access.
   2. On the Tools menu, point to Security, and then click Workgroup Administrator.
   3. In the Workgroup Administrator dialog box, click Join.
   4. Type the path and name of the workgroup information file that defines the Microsoft Access workgroup you want to join, and then click OK, or click Browse and then use the Select Workgroup Information File dialog box to locate the workgroup information file.

      The next time you start Microsoft Access, it uses the user and group accounts and passwords stored in the workgroup information file for the workgroup you joined.

2. On the Tools menu, point to Security, and then click User And Group Accounts.
3. Click the Users tab.
4. In the Name box, select Admin from the list, and then click Clear Password.

   The next time any member of the workgroup that you joined in step 1 starts Microsoft Access and opens a database, it will no longer display the Logon dialog box.