1. Create a new (blank) database.
2. Import the tables, or link them if the database is split:
File | Get External
3. Close Access. Make a copy of the mdb file. Open again.
4. Import the other objects (queries, forms, reports, macros, modules.)
5.Set minimal References under Tools | References (from the code window).
For help with references, see:
http://allenbrowne.com/ser-38.html
6. Compile (Debug menu, from the code window).
At step 4, you may find that the database fails while importing a particular
form. If so, note the form, close the database, copy the good one (result of
step 3), and try the import again without that bad form. You may find there
are other forms or reports that are corrupt as well, but the end result of
this process could be a new database that has all the data and most of the
forms and reports. You may then be able to import these last few
forms/reports from a backup copy of the database.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"advance scout" <iv*****@nospam.optonline.net> wrote in message
news:wR**************@fe09.lga...
When I repair... the data is there (the tables can be opened) and tehy
look good.... But I get an "automation error" when I run the switchboard
"advance scout" <iv*****@nospam.optonline.net> wrote in message
news:s8*************@fe11.lga... HELP! My database is suddenly corrupted. My computer was acting funny
(very sluggish) and was shut down. Access had been already been closed
down but computer was acting very slow , so perhaps it was still open. I
am now getting a "The data base ... is corrupted and needs to be
repaired" error . I have made copies of the corrupted database so that I
could try to repair and still have a corrupted copy available. When I
try to repair , it says that it has repaired the file successfully but
then it comes up as an automation error. Then when I try to restart the
"repaired " database- Access crashes.
Also in the directory I have a file with a .ldb extension... so
apparently that wasnt deleted as teh program got corrupted.
PLEASE HELP ... ANY IDEAS???