Securing Access Databases

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Establishing security for your Microsoft Access database file (.mdb) or project file (.adp) protects intellectual property such as your solution's structure and programming code. It also prevents your solution's users from inadvertently changing object designs or code in a way that would cause your solution to stop working. If your .mdb file also contains data, establishing security protects sensitive data regardless of what program is used to access your database file. This chapter discusses techniques you can use to secure your Access solution.

Contents

Protecting an Access Solution

Access User-Level Security

Securing Your Database with Access

Using VBA Code to Work with User-Level Security

Security and Database Replication

Encrypting a Database

Data Access Page Security Issues

Where to Go from Here