ACC2000: You Cannot Secure a Data Access Page in Access 2000

By using the security tools provided by Microsoft Access 2000, you cannot prevent individual users from creating data access pages in a database.

Administrators must set the permissions of all sensitive database data so that users cannot access it. When Administrators do this correctly, new pages can still be created, but they cannot contain sensitive database data.

Data access pages are objects that are linked to an individual database. But data access pages are not stored in the database. Therefore, it is entirely possible, and appropriate, for a user to create new data access pages without opening a database. Therefore, database security options would not be appropriate for data access pages.

When you secure a Microsoft Access 2000 database, note that data access pages are not listed as one of the object types in any of the security settings. For example, when you change the security options for new objects that you create in a database, you follow these steps:

1. You start Microsoft Access, and open any database.
2. On the Tools menu, you point to Security, and then click User and Group Permissions. By making selections in the Object Type box, you can add/remove user or group permissions for the following object types:
   • Database
   • Table
   • Query
   • Form
   • Report
   • Macro
   
   Note that data access pages are not listed as an object type that you can secure.

NOTE: You can also not secure a data access page by using the built-in security features of Microsoft Access projects

For additional information about securing Access databases, click the article number below to view the article in the Microsoft Knowledge Base: