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

MORE INFORMATION

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