ACC2000: You Can Make Table Design Changes to an Access Project That Is Open as Read-Only (225864)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225864
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you open an Access project as Read-Only, you notice that you can still make design changes to the tables.

CAUSE

The Read-Only property does not affect the design of Access project tables.

RESOLUTION

If you want to limit which users can make design changes to a table in an Access project, use SQL Server Security. To open the SQL Server Security dialog box, point to Security on the Tools menu, and then click Database Security.

For more information about how to revoke permissions, refer to SQL Server 7.0 Books Online, which is available for download from the following Microsoft Web site:

http://download.microsoft.com/download/SQL70/File/2/Win98/En-US/SQLBOL.exe

In SQL Server Books online, on the Search tab, search for the string how to revoke permissions.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start Access 2000.
  2. In the opening dialog box, make sure More Files is selected, and then click OK.
  3. In the Open dialog box, browse to the sample Access project NorthwindCS.adp, and select it.
  4. Click the arrow next to Open, and then click Open Read-Only. When you are prompted that the database is Read-Only, click OK.
  5. Open the Products table in Design view.
  6. Add a new field at the bottom called Test with a data type of char.
  7. Close the table and reopen it in Datasheet view. Note that the char field Test appears, indicating that the table design has been changed.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbdownload kbprb KB225864
©2004 Microsoft Corporation. All rights reserved.