Repairing Access 2002 Database

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

My database (front end) was corrupted when our tech messed
with my computer. The Access 2002 "compact and repair"
utility does repair the file, but instead gives me a
message saying "Microsoft Access has detected corruption
in this file. . ." Does anyone have any utilities that
may have a chance of repairing this database? (This DB is
open at all times, the backup our computer people run does
not back up open file (I now find out) and therefore has
not been backed up since August). I can open the DB front
end. I can see the objects. My macros and queries are
okay. It is just the forms, reports, and modules that I
cannot get into properly. HELP!!

Chaplain Doug
 
Let's try some basic attempts. First, make a copy of the file in case we make things
worse.

Try to open the file with the following command line:

"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /excl /decompile

Also, add switches for user name, password, and/or workgroup file if you normally need
them. Once the database is open, do a Compact/Repair. If that completes successfully, then
open a code window (Alt+F11) and go to Debug|Compile to recompile the database. Close the
code editor and Compact/Repair once more for good measure.

If that doesn't work, try creating a new, blank database and import the objects from the
corrupted one. If importing them all at once doesn't work, you may want to import them one
at a time (time consuming, I know) and see if you can isolate which object is the bad one.
 
tHANKS wAYNE. tRIED TO NO AVAIL. i AM NOW RECOVERING AS
BEST AS POSSIBLE, INCLUDING RECODING SOME MODULES (ONLY TO
REFLECT CHANGES i MADE SINCE THE LAST BACKUP) AND
REDESIGNING SOME FORMS AND REPORTS. i WAS ABLE TO GET THE
QUERIES AND MACROS AND THE DATA (TABLES) IN THE BACKEND
ARE OKAY.
 
If you're having to do everything manually and can get to the modules, the text of the
modules should be ok and you can copy and paste that.
 
Chaplain Doug said:
My database (front end) was corrupted when our tech messed
with my computer. The Access 2002 "compact and repair"
utility does repair the file, but instead gives me a
message saying "Microsoft Access has detected corruption
in this file. . ." Does anyone have any utilities that
may have a chance of repairing this database?
Click to expand...

From other postings in this thread sounds like you're doing reasonably
well. In the future though you can also visit the Access Corruptions
FAQ at my website.
(This DB is
open at all times, the backup our computer people run does
not back up open file (I now find out) and therefore has
not been backed up since August).
Click to expand...

HOW TO: Detect User Idle Time or Inactivity in Access 2000 (Q210297)
http://support.microsoft.com/?kbid=210297
ACC: How to Detect User Idle Time or Inactivity (Q128814)
http://support.microsoft.com/?kbid=128814

However we found that the code which runs on the timer event must be
disabled for the programmers. Otherwise weird things start happening
when you're editing code.

Also print preview would sometimes not allow the users to run a menu
item to export the report to Excel or others. So you had to right
click on the Previewed report to get some type of internal focus back
on the report so they could then export it. This was also helped by
extending the timer to five minutes.

The downside to extending the timer to five minutes was if a person
stays in the same form and at the same control for considerable parts
of the day, ie someone doing the same inquiries, the routine didn't
realize that they had actually done something. I'll be putting in
some logic sometime to reset this timer whenever they do something in
the program.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top