Compact and Repair Database Utility

[sales@scantechintl.com]

Hi,

I have an Access 2002 database.

I used to be able to run the "Compact" utility but a few months ago it

"Table 'TempMSysAccessObjects' already exits"

The result being that I couldn't complete the repair.

Any ideas on how to fix the problem?

Thank you,
John Tamaro

 

[a.sinatra]

You may have to create a new mdb and import everything into it from your old database.
________
Cb900f

 

[ghudson]

Have your tried the free Microsoft Jet Compact utility? Click on the link below for the version of Access you are using. For more details, search the Microsoft Knowledgebase for Jet Compact. I have had a lot of success using Jet Compact to repair a db when I thought it was corrupted and Access could not repair itself.

Access 97: Updated Version of Microsoft Jet 3.5 Available for Download

Access 2000: Jet Compact Utility Available in Download Center

Access 2002: Jet Compact Utility Available in Download Center

HTH

 

[sales@scantechintl.com]

You may have to create a new mdb and import everything into it from your old database.

You're right.

Before creating a new MDB, I compiled the DB first. There were two(minor) errors.

I then imported the objects, running the Compact utility after import each object to make sure nothing was corrupt.

Thank you very much for your tip.

John

 

[sales@scantechintl.com]

Have your tried the free Microsoft Jet Compact utility? Click on the link below for the version of Access you are using. For more details, search the Microsoft Knowledgebase for Jet Compact. I have had a lot of success using Jet Compact to repair a db when I thought it was corrupted and Access could not repair itself.

Access 97: Updated Version of Microsoft Jet 3.5 Available for Download

Access 2000: Jet Compact Utility Available in Download Center

Access 2002: Jet Compact Utility Available in Download Center

HTH

Hi,

I imported the Jet Compact Utility. It gave an error message and didn't fix the problem.

I finally created a new MDB and imported everything (see previous message)

Thank you for trying.

John