Data Base Compact Utility 4.0

  • Thread starter Thread starter RobUCSD via AccessMonster.com
  • Start date Start date
R

RobUCSD via AccessMonster.com

I'm using Data Base Compact Utility 4.0 to compact a Access 2003 Data Base
and I get the message, "Error compacting database"

I'm trying to compact this way as I'm following EveryThingAccess's procedures
for fixing a corrupt database.

In my database, I keep getting weird things happening with queries. I've
deleted all the problem queries, compacted, decompiled, compacted, created
new blank database with autocorrect turned off, imported all the objects from
the corrupted db, compiled, compacted, and I still get the same problem. When
I try to recreate the problem queries manually, I get prompted for a criteria
that isn't in the new query, it was in the old query.

Any suggestion would be greatly appreciated. Thanks, Rob
 
There is a good chance that it is corrupted if you are unable to divest old
objects. Just run the code described, supplying your own paths. You'll see
the text files created. The run the code again (with
Application.LoadFromText)
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

RobUCSD said:
Hi Arvin, thanks for your response.

Are you recommending this because my database may be corrupted?

Do you have any more details on how to implement this?

Thanks, Rob
Click to expand...
 
Back
Top