Microsoft KB Archive/225864

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

Article ID: 225864

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

Additional query words: prb

Keywords: kbdownload kbprb KB225864

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.