Microsoft KB Archive/190638

= ACC97: Insert Data Permission Required to Modify Table Design =

Article ID: 190638

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q190638



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



SYMPTOMS
When you try to open a table in Design View, you may receive the following warning message:

You can't open the table for modification.

If you then modify the design of the table, you can only save the changes as an external file, an external database, or within the current database as a new table with a new name.



CAUSE
You may experience these symptoms if the following conditions are true:


 * All permissions have been removed from the table for the user and all groups that the user belongs to.

-and-
 * The Modify Design permission has been applied for the user or a group that the user belongs to.



RESOLUTION
To avoid the warning message and to be able to make design modifications to the existing table, click to select the Insert Data check box in addition to the permissions automatically granted by selecting the Modify Design check box.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.



Steps to Reproduce Problem
Create a New Blank Database

---


 * 1) Start Microsoft Access 97. Log on as Admin.
 * 2) Create a new database with a name of your choice using the default System.mdw.
 * 3) Create a new table named Table1.

Set Permissions

---


 * 1) Remove all permissions for the Admin user on Table1, and then click Apply.
 * 2) Grant Modify Design permissions to Admin on Table1.

NOTE: The following permissions are also automatically granted when the Modify Design check box is selected: Read Design, Read Data, Update Data, and Delete Data. Also note that the Insert Data check box is not selected.
 * 1) Remove all permissions for Table1 from the Admins and Users groups.

Reproducing the Warning Message

---


 * 1) Try to open Table1 in Design view.

Note that you receive the warning message.
 * 1) Modify the design of Table1 by adding a new field and try to close the table. Note that the Save As dialog box appears.
 * 2) Grant Insert Data permission to Admin on Table1.
 * 3) Repeat step 6. Note that you can now modify Table1 within the database.

EXPECTED BEHAVIOR: When you click to select the Modify Design check box when assigning permissions, the defaults should include checking the Insert Data check box if this permission is required to modify the design of the table.

Additional query words: you can t open the table for modification

Keywords: kbbug kberrmsg kbnofix KB190638

-

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

© Microsoft Corporation. All rights reserved.