Log on to an Access workgroup

The Logon box is displayed only if the logon procedure has been activated for your Microsoft Access workgroup. Once the logon procedure has been activated, you must identify yourself at startup by entering a valid user account name. If a password has been added to a user account, you must also enter the password.

1. Start Microsoft Access.
2. If necessary, change to the workgroup that contains the user account you want to use to log on by using the Microsoft Access Workgroup Administrator.

   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.

3. Open a database. If the logon procedure has been activated, the Logon box is displayed.
4. Type your user account name in the Name box. Your user account name isn't case-sensitive.
5. If your password has been defined, type your password in the Password box; otherwise, leave it blank. Passwords are case-sensitive.