Data Base Compact Utility 4.0

[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

 

[Arvin Meyer [MVP]]

Try using SaveAsText and LoadFromText to build a new database.:

http://www.datastrat.com/Code/DocDatabase.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

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

Try using SaveAsText and LoadFromText to build a new database.:

http://www.datastrat.com/Code/DocDatabase.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

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

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