• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Keeping Your Information Secure > Preventing Changes to a Database

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint