ACC2000: You Cannot Secure a Data Access Page in Access 2000 (200213)


The information in this article applies to:

  • Microsoft Access 2000
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:
  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

REFERENCES

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

254372 ACC2000: Overview of How to Secure a Microsoft Access Database

Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbDAP kbinfo KB200213
©2004 Microsoft Corporation. All rights reserved.