Compact and Repair Database Messed up a query of mine (i think)

[RZ15]

Hi,

I was working on a query this morning and everything was working fine. Some time in the last half hour, I used the Compact & Repair Database feature. After that, when I went to open the query in design view, and also tried to run the query afterwards, they both gave me the same result: Access would close with no error message at all. I can't think of anything other than the Compact & Repair Database that could've done this. Now this isn't catastrophic, as I have a copy that I backed up not too long ago, but I want to understand what the **** happened so I can avoid this in the future.

Was it the Compact & Repair that did this? Has there been other cases of this happening?

Thanks in advance,

Raza



EDIT: it messed up MULTIPLE queries of mine.

[nico5038]

Hi Raza,

As you found out, it's rather easy to get a corrupted Access database.
In general the Compact & Repair won't cause this, but there can be exceptions...

One certain way of getting into trouble is to delete a form and then, without a compact & repair and/or open and close of the.mdb, create a new form with the same name....

For corrupt databases I use the following recovery steps:
1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support.../Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default...;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default...b;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm

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


Nic;o)

[missinglinq]

And as you've probably figured out, make a backup before doing a compact and repair, or any other major app altering maneuver!

Linq ;0)>