O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required