How do I automate the restoration of a corrupt database?

[smercer]

Hi all

I am on the last parts of my Books database and am wondering if It is possible to automate the process of un-corrupting a database.

here are some ideas I had:

1) after doing research I found that corrupted records have #Deleted in it and when refreshed will not go away. is it possible to have a query that will search for records that have hieroglyphics (or #Deleted or what ever that makes it corrupted) in them.

2) when the records are found using the method in section 1 I would then have code that will lookup in the backup for the missing record.


I would like to hear peoples opinons on this.

Thanks in advance!!!

 

[llkhoutx]

On a compact and repair, among other things, a rogram restarts. I suppose one could put a Button on a form to compact and reapir.

 

[smercer]

On a compact and repair, among other things, a rogram restarts. I suppose one could put a Button on a form to compact and reapir.

I have the data base compact on close as set in the database options, but I don't know if it is the same as Tools/Database utillities/Compact and repair.

The compact and repair does not always work, but is usualy the first option to do

 

[llkhoutx]

A "compact" is not the same as "compact & repair," it merely reclaims database space that was created by temporary queries, etc.

I found that corrupted records have #Deleted in it and when refreshed will not go away

I suspect the foregoing indicates deleted records, not corrupt ones. I doubt that one can read or access a corrupt record. After a requery for a form, #Deleted records are no longer visible. A "Refresh" does not have the same effect as a requery. The requery rebuilds the record dynaset (eliminating deleted records); the Refresh does not.

 

[smercer]

I suspect the foregoing indicates deleted records, not corrupt ones.

Quote from website
http://support.microsoft.com/kb/209137/EN-US/

The symptoms of a corrupted database can range from "#Deleted" appearing in certain records

Have a look at the site, it is quite interesting.

 

[llkhoutx]

I haven't seen that site before, it's a lot to digest.

First sentence . . .

I've been using Access since '91 and have never seen #Deleted in a corrupted table.

Live and learn.

 

[smercer]

Yes, there is always something to learn.