Tuesday, July 29, 2014

How To Activating User Logons in Access 2003

Until you activate the logon procedure for a workgroup, Access automatically logs on all users in the Admin account, giving them complete control over all databases. You can force users to log on to Access by creating a nonblank password in the Admin account.

Activate the Logon Procedure

graphics/1_icon.jpg
Start Access as the Admin user (the initial setting for Access).
graphics/2_icon.jpg
Click the Tools menu, point to Security, and then click User And Group Accounts.
graphics/3_icon.jpg
Click the Change Logon Password tab.
graphics/4_icon.jpg
Verify that the current user is Admin.
graphics/5_icon.jpg Type a password.
You do not need to type a password in the Old Password box, because until this moment, no password should have been defined for the Admin account.
graphics/6_icon.jpg
Verify the password by retyping it in the Verify box.
graphics/7_icon.jpg
Click OK.
graphics/12inf05.jpg

Did You Know?

You can add other user passwords. To create passwords for other users, log on as those users and create a password in the same way you created a password for the Admin account.
You can remove a password. If a user forgets his or her password, log on as Admin, and then click Clear Password, on the Users tab in the User And Group Accounts dialog box.
You can disable user logons. To disable user logons, remove the password for the Admin account.