By default, Access assigns the same name to the project containing your VBA modules and procedures as your database's name. You can change the project's name to make it more descriptive. You can also password-protect your VBA project to keep other users from accessing and changing your procedures.
Set Project Properties
Open the Visual Basic Editor by pressing and holding Alt while pressing F11.
Select your project from the list of projects in Project Explorer.
Click the Tools menu, and then click ProjectName Properties, where ProjectName is the current name of your project.
Click the General tab.
Enter a new name for your project, if necessary.
Enter a description of your VBA project.
Click the Protection tab.
Click the Lock Project For Viewing check box if you want to keep others from viewing your project's source code.
Enter a password to unlock the project for viewing.
Confirm the unlocking password.
Click OK.
Did You Know?
You need to remember your project password. Save your password. If you lose it, you will not be able to open your code to edit it later.
|
