Can't Compact my Database

[Guest]

Every time I go to compact my database, Access shows, "Unrecognized Data
Format 'P:\...\...\...\file name.accdb'". I can't compact this. Previously,
I had set it to automatically compact, but that actually corrupted the file
beyond repair so I couldn't even open it.

Please tell me how I can compact this file.

 

[Arvin Meyer [MVP]]

It sounds like it's corrupt again.

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Try importing all the objects into a new empty database.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Guest]

Arvin,

I had two different coworkers try compacting this database on their
computers and they had no problems. Could there be some setup on my Excel
options, etc, that is causing this problem? However, it only happens with
this one database. I had some options set that are file specific too, but I
tried to eliminate all of those and it still has that error. One coworker is
using Vista with Access 2007, the other is using XP with Access 2007.

Mark.