Microsoft KB Archive/200213

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

Article ID: 200213

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q200213



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



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



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



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:  You start Microsoft Access, and open any database. 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</li> Report</li> Macro</li></ul>

Note that data access pages are not listed as an object type that you can secure.</li></ol>

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

<div class="references_section">