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
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.
Oct 12 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
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:
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)
Oct 12 '07 #2

missinglinq
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.