Preventing Changes to a Database
If you have added VBA procedures to a database, you certainly don’t want users who aren’t qualified or authorized to make changes to your code. You can prevent unauthorized access in two ways: you can protect your VBA code with a password, or you can save the database as a Microsoft Database Executable (MDE) file. If you set a password for the code, it remains available for editing by anyone who knows the password. If you save the database as an MDE file, people using the file can run your code, but they can’t view or edit it.
In this exercise, you will secure the VBA code in a database by assigning a password to it.
USE the GardenCo database in the practice file folder for this topic. This practice file is located ...
Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
