ACC1x: "Object Not Found" Error When Compacting Database |
Q109367
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1
SYMPTOMS
When you are compacting a database, the error message
Object Not Found <Filename>.MDB
occurs. <Filename> is the name of the database file you are trying to compact.
CAUSE
The database's System tables may be corrupted, or the MSysObjects table contains a pointer to an object in one of the other System tables that no longer exists.
RESOLUTION
Try to following steps to find the cause of the error and correct the problem:
- Make a backup copy of the .MDB file.
- Open the .MDB file in Microsoft Access.
- Identify the corrupted object by opening every object in the database in Design view. When you try to open a corrupted object in Design view, you should receive an error message stating that the object does not exist, or that you do not have permissions to the object, even though you do.
- After you have identified the corrupted object, close the database and then create a new database. Import all the good tables from the original database to the new database. Compact the new database to make sure that it will compact correctly.
- Repeat step 4 for the queries, forms, reports, macros, and modules in the original database, excluding any corrupted objects. Make sure to compact the new database after you import each object type.
- In the new database, re-create any object that you identified as corrupted in the original database.
- In the new database, re-create any table relationships that exist in the original database.
- In the new database, re-create any Import/Export specifications that exist in the original database.
STATUS
This problem no longer occurs in Microsoft Access version 2.0.
REFERENCES
Microsoft Access "User's Guide," version 1.1, Chapter 4, "Importing or Attaching Objects from Microsoft Access Databases," pages 68-69, and Chapter 25, "Compacting a Database," pages 636-637
Keywords : kberrmsg kbusage
Issue type : kbprb
Technology :
Last Reviewed: November 4, 2000 |