Database corrupted error

advance scout

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???

Jun 25 '06 #1

advance scout

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???

Jun 25 '06 #2

Allen Browne

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???

Jun 26 '06 #3

advance scout

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" <Al*********@SeeSig.Invalid> wrote in message
news:44**********************@per-qv1-newsreader-01.iinet.net.au...

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???

Jun 29 '06 #4

advance scout

I was able to copy and paste tables and I get some data loss but at least I
am able to continue invoicing (Whew.. I am in my busy season)... I will
retry using your suggestions.of importing ... But before I do...any idea
what is causing the "automation error" when I compile. Its always at the
same line in the switchboard class module:

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

Dim dbs As Database
Dim rst As Recordset

The Dim dbs As Database is highlighted. Maybe if I could get it past that
point I would be ok.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:44**********************@per-qv1-newsreader-01.iinet.net.au...

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???

Jun 29 '06 #5

Allen Browne

That sounds like a problem with references.

If this is Access 2000 later, in the code window, choose References on the
Tools menu.
Check the box for:
Microsoft DAO 3.6 Library.

More info on references for each version of Access, and how to solve
reference issues:
http://allenbrowne.com/ser-38.html

--
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:40***************@fe10.lga...

I was able to copy and paste tables and I get some data loss but at least I
am able to continue invoicing (Whew.. I am in my busy season)... I will
retry using your suggestions.of importing ... But before I do...any idea
what is causing the "automation error" when I compile. Its always at the
same line in the switchboard class module:

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

Dim dbs As Database
Dim rst As Recordset

The Dim dbs As Database is highlighted. Maybe if I could get it past that
point I would be ok.

Jun 30 '06 #6

advance scout

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:44***********************@per-qv1-newsreader-01.iinet.net.au...

That sounds like a problem with references.

If this is Access 2000 later, in the code window, choose References on the
Tools menu.
Check the box for:
Microsoft DAO 3.6 Library.

Access 97- I tried the references ... No good. I still get the automation
error. It did correct the date problem I was having though. But I still
cant get past the compile

Jun 30 '06 #7

Allen Browne

The Automation error may mean that Access is unable to resolve the name of
something.

Double-check that nothing on that line (even later on the line) could be
misunderstood.

Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

--
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:eL***************@fe08.lga...

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:44***********************@per-qv1-newsreader-01.iinet.net.au...

That sounds like a problem with references.

If this is Access 2000 later, in the code window, choose References on
the Tools menu.
Check the box for:
Microsoft DAO 3.6 Library.

Access 97- I tried the references ... No good. I still get the
automation error. It did correct the date problem I was having though.
But I still cant get past the compile

Jul 1 '06 #8

advance scout

My newsgroup server has become unreliable so I dont know if this will post
to the newsgroup...But if it does I want to say thanks Allen...

I got the database working by using your advise.. i.e. importing tables,
queries, forms, modules etc. Found that my "invoice" form was corrupt
....that was the problem... so I used an older version. After I got it
working I split the database into a front and back end and then did append
queries (I had kept invoicing customer susing an older version.)

Works great now... WHEW! I learned a lesson...frequent backups. The split
database should help too! Thanks a lot!
"advance scout" <iv*****@nospam.optonline.netwrote 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???

Jul 2 '06 #9

Allen Browne

Good news! Thanks for sharing.

--
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.netwrote in message
news:gx**************@fe11.lga...

My newsgroup server has become unreliable so I dont know if this will post
to the newsgroup...But if it does I want to say thanks Allen...

I got the database working by using your advise.. i.e. importing tables,
queries, forms, modules etc. Found that my "invoice" form was corrupt
...that was the problem... so I used an older version. After I got it
working I split the database into a front and back end and then did append
queries (I had kept invoicing customer susing an older version.)

Works great now... WHEW! I learned a lesson...frequent backups. The split
database should help too! Thanks a lot!
"advance scout" <iv*****@nospam.optonline.netwrote 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.

Jul 2 '06 #10