This topic provides reference information about:
Visual Basic for Applications (VBA) passwords
The first kind of password is called a "database password." If you set a database password, all users must enter that password before they are allowed to open the database. Adding a database password is an easy way to prevent unwanted users from opening your database; however, once a database is open, no other security measures are provided unless user-level security has been defined as well. If you have user-level security defined for your database, you can prevent users from setting a database password.
Return to top
The second kind of password is called a "security account password" and is only used when user-level security has been defined for a workgroup. A security account password is created to make sure that no other user can log on using that user name.
By default, Microsoft Access assigns a blank password to the default Admin user account and to any new user accounts that you create in your workgroup. As part of securing a database, it's important to add a password to:
In addition, you might want to add passwords to the accounts you create for users, or instruct users to add their own passwords.
Users can create or change their own user account passwords; however, only an administrator account can clear a password if a user forgets the password.
Return to top
The third kind of password is called a Visual Basic for Applications (VBA) password. You use this password once per session to protect VBA code in modules and modules behind forms and reports. This password prevents unauthorized users from editing, cutting, pasting, copying, exporting, and deleting VBA code.
Return to top