Microsoft KB Archive/96011

{|
 * width="100%"|

ACC1x: No System Table Permissions After Admin User Deleted

 * }

Q96011

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
Your attempt to access the system tables MSysACES, MSysColumns, or MSysIndexes fails.

CAUSE
You deleted the Admin account from the list of valid users.

RESOLUTION
Before you delete the Admin account, you must assign permissions for the system tables to a new member of the Admins group.

STATUS
This behavior is by design.

MORE INFORMATION
The text below explains how to assign permission to access the system tables to a new member of the Admins group.

If you create a new Admin account and delete the original Admin account from the Users group before you assign the new account access rights, you are unable to access the system tables. The one exception to this rule applies if the original Admin did not create the database.

To assign permissions to the system tables, use the following steps:


 * 1) Log on to Microsoft Access as the user Admin. If you do not receive a logon screen, you are automatically logged in as Admin.
 * 2) From the Security menu, choose Users.
 * 3) In the Users dialog box, choose New.
 * 4) Enter the name of the new administrator, assign the administrator a PIN (personal identification number), and choose OK.
 * 5) In the Group Membership section of the Users dialog box, add the new administrator to the group Admins. To do so, select Admins in the Available Groups list and choose Add. Then choose Close.
 * 6) From the View menu, choose Options.
 * 7) In the Items box in the General category, set Show System Objects to Yes and choose OK.
 * 8) From the Security menu, choose Permissions.
 * 9) In the Object section of the Permissions dialog box, select the MSysACES table. In the Permissions section, select the Full Permissions check box. Microsoft Access sets all other permissions automatically.

Repeat step 9 for the MSysColumns and MSysIndexes tables.