Re: Database corrupted error

Thanks for the reply Allen- I have been on the road but I will try your
solutions and let you know how I make out




"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:449f4aa7$0$6627$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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" <ivanhoe@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:wRBng.265$V27.24@xxxxxxxxxxx
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" <ivanhoe@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:s8Bng.89$9y4.72@xxxxxxxxxxx
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???




.