ACC1x: No System Table Permissions After Admin User Deleted

ID: Q96011


The information in this article applies to:


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.


REFERENCES

Microsoft Access "User's Guide," version 1.0, pages 616-623

For more information, search for "permissions," then "Adding Users to Groups," and "Assigning Permissions to Users" using the Help menu.


Keywords          : kbusage ScrtOthr 
Version           : 1.0 1.1
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: March 19, 1999