472,145 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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


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
2 1663
3,080 Expert 2GB
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

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: http://www.granite.ab.ca/access/corruptmdbs.htm

Oct 12 '07 #2
3,532 Expert 2GB
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.

Similar topics

2 posts views Thread by barbara_dave | last post: by
5 posts views Thread by SheldonMopes | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.