By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,081 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,081 IT Pros & Developers. It's quick & easy.

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

P: 53

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,


EDIT: it messed up MULTIPLE queries of mine.
Oct 12 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
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:
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database;en-us;306204

4) Bit "heavier":
Access decompile:

5) Try a recovery tool / Table rescue
Table datarecovery:
Access recovery:

6) Ask a company (will cost $$'s ! )

check also:

Oct 12 '07 #2

Expert 2.5K+
P: 3,532
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)>
Oct 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.