Require users to log on to Microsoft Access

Until you activate the logon procedure for a workgroup, Microsoft Access automatically logs on all users at startup using the predefined Admin user account. You require users in a workgroup to log on by adding a password to the Admin user account.

1. Join the workgroup with the logon procedure you want to activate.

   How?

2. Start Microsoft Access, and then open a database.
   
   
3. On the Tools menu, click Security, and then click User And Group Accounts.
   
   
4. Click the Users tab, and make sure that the predefined Admin user account is highlighted in the Name box.
   
   
5. Click the Change Logon Password tab, click the New Password box, and type the new password. Don't type anything in the Old Password box.

   To maintain the security of your password, Microsoft Access displays asterisks (*) as you type. Passwords can be from 1 to 20 characters, and can include any characters except ASCII character 0 (null). Passwords are case-sensitive.

6. Verify the password by typing it again in the Verify box, and then click OK.

   The Logon dialog box is displayed the next time any member of the workgroup that you joined in step 1 starts Microsoft Access and opens a database. If no user accounts are currently defined for that workgroup, the Admin user is the only valid account at this point. For information on defining user accounts, click .

Note   When you secure a database, you create user accounts in a Microsoft Access workgroup, and then assign permissions for databases, tables, queries, forms, reports, and macros to those accounts and to any group accounts to which they belong. When users log on to Microsoft Access by using their accounts, they have only the permissions associated with those accounts. Users log on to Microsoft Access by typing a user name and password in the Logon dialog box.