Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 198915 - Last Review: January 26, 2005 - Revision: 2.1
ACC2000: Insert Data Permission Required to Modify Table Design
This article was previously published under Q198915
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
When you try to open a table in Design view, you may receive the following
warning message:
You can't open the table <tablename> 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.
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
to which the user belongs.
To avoid the warning message and 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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Problem
- Start Access 2000. Log on as Admin.
- Create a new database with a name of your choice using the default System.mdw.
- Create a new table named Table1.
- On the Tools menu click Security and then User and Group Permissions.
-
Remove all permissions for the Admin user on Table1, and then click Apply.
- 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.
-
Remove all permissions for Table1 from the Admins and Users groups.
-
Try to open Table1 in Design view.
Note that you receive the warning message described in the Symptoms section of this article. - Modify the design of Table1 by adding a new field and try to close the table. Note that the Save As dialog box appears.
- Grant Insert Data permission to Admin on Table1.
- Repeat step 6. Note that you can now modify Table1 within the
database.
EXPECTED BEHAVIOR: When assigning permissions, if you click to select the
Modify Design check box, the defaults should include checking the
Insert Data check box if this permission is required to modify the design of the table.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kbbug kberrmsg kbpending KB198915 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate