ACC97: Error Message Appears When You Compact or Convert a Database (301869)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q301869
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you attempt to compact or convert a database file (.mdb or .mde), one of the following error messages may appear:
Records cannot be read, no read permissions on database path\name
No Read permissions on object name
If you try using the Jetcomp.exe utility to compact the file, you receive the same error message.

System tables also appear in the Database window.

CAUSE

This behavior can occur for either of the following reasons:
  • Some of the system tables cannot be read or copied. This might be an ownership issue. For example, the tables might be owned by the Jet database engine.
  • You might not be logged on to the database through the correct user group.

RESOLUTION

To resolve this error message if some of the system tables cannot be read or copied, hide the system tables:
  1. On the Tools menu, click Options, and then click the View tab.
  2. Under the Show group, click to clear the System Objects check box, and then click OK.
  3. Try again to compact or convert the database.
To resolve this error message if the owner of the database object is not a member of the Admin group:
  1. Click Tools, point to Security, and then click User and Group Permissions.
  2. In the User and Group Permissions dialog box, click the Change Owner tab, and then look at the Object list to see whether any of the database objects are owned by <unknown>.

    For the database objects where you need to change the ownership:
    1. If the database is secured, you must join the correct workgroup information file, and then log on to the database either as a member of the Admin group or as a user of a group that has Read Design/Read Data permissions to all database objects.
    2. In the Object list, click the object or objects whose ownership you want to change. To select more than one object, press and hold CTRL while you click the objects.
    3. In the New Owner box, click Admin, and then click Change Owner.
    4. To verify the ownership of all objects in the database, click the various objects that are available in the Object Type box, and change the ownership if necessary.
    5. Click OK to close the User and Group Permissions dialog box.
  3. Try again to compact or convert the database.
Modification Type:MajorLast Reviewed:10/22/2003
Keywords:kberrmsg kbprb KB301869
©2003 Microsoft Corporation. All rights reserved.