Database corruption problem

HELP! My database is suddenly corrupted. My computer was acting funny
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12045-database-corruption-problem.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
(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 the program got corrupted.

PLEASE HELP ... ANY IDEAS???

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On Sun, 25 Jun 2006 1504 -0400, "advance scout"
wrote:

>HELP! My database is suddenly corrupted. My computer was acting funny
>(very sluggish) and was shut down.

Have you run a *competent* virus and malware scan?

>Access had been already been closed down
>but computer was acting very slow , so perhaps it was still open.

That could certainly do it.

>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-
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
>Access crashes.
>
>Also in the directory I have a file with a .ldb extension... so apparently
>that wasnt deleted as the program got corrupted.
>
>PLEASE HELP ... ANY IDEAS???

First - get AVG, or McAfee, or Norton Antivirus, or SOME good
antivirus program and make sure your computer isn't infected with a
virus. Then get a good spyware program (AdAware, Spybot, or both) and
make sure you don't have some spyware program.

Then check out the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045

You may need to restore this database from a functional backup
(hopefully you have one :-{( ) or recreate it. Databases are NOT
immortal.

John W. Vinson[MVP]

Hi John-

No Virus-

when I run the repair it says its repaired .. but it stops as its trying to
run the switchboard script - I get an "automation error".

When I go into tables ... all my tables are there with the data ...HURRAY!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
So the data is there but I am getting an automation error after the repair.

All my OLD access databases are working but they are old data (havent backed
up in a about a month)... and those scripts are still working...

So something is happening in the repair to give me an "automation error " on
the switchboard.





"John Vinson" wrote in message
news:c3pt929pqtfr6vjttgq81j85nrhmi2vrs7@4ax.com...
> On Sun, 25 Jun 2006 1504 -0400, "advance scout"
> wrote:
>
>>HELP! My database is suddenly corrupted. My computer was acting funny
>>(very sluggish) and was shut down.
>
> Have you run a *competent* virus and malware scan?
>
>>Access had been already been closed down
>>but computer was acting very slow , so perhaps it was still open.
>
> That could certainly do it.
>
>>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
>>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 the program got corrupted.
>>
>>PLEASE HELP ... ANY IDEAS???
>
> First - get AVG, or McAfee, or Norton Antivirus, or SOME good
> antivirus program and make sure your computer isn't infected with a
> virus. Then get a good spyware program (AdAware, Spybot, or both) and
> make sure you don't have some spyware program.
>
> Then check out the suggestions at
> http://www.granite.ab.ca/access/corruptmdbs.htm
>
> You may need to restore this database from a functional backup
> (hopefully you have one :-{( ) or recreate it. Databases are NOT
> immortal.
>
> John W. Vinson[MVP]

the exact error is " Compile error: automation error"

So the question is why would I get this error after the database has been
repaired? Since the data is all there once this is fixed I will have a
working database. I have tried compiling... to no avail.




"advance scout" wrote in message
news:PPBng.264$V27.77@fe09.lga...
> Hi John-
>
> No Virus-
>
> when I run the repair it says its repaired .. but it stops as its trying
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
> to run the switchboard script - I get an "automation error".
>
> When I go into tables ... all my tables are there with the data ...HURRAY!
> So the data is there but I am getting an automation error after the
> repair.
>
> All my OLD access databases are working but they are old data (havent
> backed up in a about a month)... and those scripts are still working...
>
> So something is happening in the repair to give me an "automation error "
> on the switchboard.
>
>
>
>
>
> "John Vinson" wrote in message
> news:c3pt929pqtfr6vjttgq81j85nrhmi2vrs7@4ax.com...
>> On Sun, 25 Jun 2006 1504 -0400, "advance scout"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
>> wrote:
>>
>>>HELP! My database is suddenly corrupted. My computer was acting funny
>>>(very sluggish) and was shut down.
>>
>> Have you run a *competent* virus and malware scan?
>>
>>>Access had been already been closed down
>>>but computer was acting very slow , so perhaps it was still open.
>>
>> That could certainly do it.
>>
>>>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 the program got corrupted.
>>>
>>>PLEASE HELP ... ANY IDEAS???
>>
>> First - get AVG, or McAfee, or Norton Antivirus, or SOME good
>> antivirus program and make sure your computer isn't infected with a
>> virus. Then get a good spyware program (AdAware, Spybot, or both) and
>> make sure you don't have some spyware program.
>>
>> Then check out the suggestions at
>> http://www.granite.ab.ca/access/corruptmdbs.htm
>>
>> You may need to restore this database from a functional backup
>> (hopefully you have one :-{( ) or recreate it. Databases are NOT
>> immortal.
>>
>> John W. Vinson[MVP]
>
>

On Sun, 25 Jun 2006 1659 -0400, "advance scout"
wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045

>the exact error is " Compile error: automation error"
>
>So the question is why would I get this error after the database has been
>repaired? Since the data is all there once this is fixed I will have a
>working database. I have tried compiling... to no avail.

Repair isn't foolproof.

Again... check the suggestions on Tony's website. He has some
suggestions (and links to other sites) with ways to repair databases
that the builtin Access repair tool can't. One place to start would be
to create a new, empty database; link to your tables (I hope this is a
split application with a backend of tables and a frontend of
everything else); and Import all the forms, reports, etc. Type Ctrl-G
to open the VBA editor and select Debug...Compile.


John W. Vinson[MVP]

"John Vinson" wrote in message
news:lcvt92hlrp03rc63rjdi68ravrclr9tj8m@4ax.com...
> On Sun, 25 Jun 2006 1659 -0400, "advance scout"
> wrote:
>
>>the exact error is " Compile error: automation error"
>>
>>So the question is why would I get this error after the database has been
>>repaired? Since the data is all there once this is fixed I will have a
>>working database. I have tried compiling... to no avail.
>
> Repair isn't foolproof.
>
> Again... check the suggestions on Tony's website. He has some
> suggestions (and links to other sites) with ways to repair databases
> that the builtin Access repair tool can't. One place to start would be
> to create a new, empty database; link to your tables (I hope this is a
> split application with a backend of tables and a frontend of
> everything else);
No, its not ;(

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
I do have a working version of the database from about two months ago. The
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
only thing that would have changed are the tables. so can I split the old
database ? and if so how do i do that?

Thanks for your help.


and Import all the forms, reports, etc. Type Ctrl-G
> to open the VBA editor and select Debug...Compile.
>
>
> John W. Vinson[MVP]

On Sun, 25 Jun 2006 17:47:02 -0400, "advance scout"
wrote:


>I do have a working version of the database from about two months ago. The
>only thing that would have changed are the tables. so can I split the old
>database ? and if so how do i do that?

You're in luck. Back up this two-month old database AND your current
database.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045

I'd suggest manually doing the split, rather than using the splitter
wizard.

You can do so by doing the following steps:

Take your working two-month old database (you DID back it up...
right!?), take a deep breath, and delete all the tables. Compact it.

Create a new, empty database. Be sure to set the Options so that Name
Autocorrect is off (it's buggy). Then use File... Get External Data...
Import and import all the tables (with the current up to date data)
from your current database, the corrupt one. Compact this. Name it
whatever you like, but if your database is named RALPH.MDB, you might
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
want to name it RALPH_BE.MDB (_BE for Back End).

Then open the database from which you deleted the tables, and use
File... Get External Data... Link and link to the tables in this newly
created database.

John W. Vinson[MVP]

Thanks John.... BUT.... Something really weird is going on.... It seems
that when I open the old database (remember it was not affected by the
shutdown) i am getting weird errors there too- example the date() function
is missing... all of my reports have question marks where that function is
used... some other global errors too... This is a copy on a CD that should
be totally unaffected but when I copy it to my hard drive and open it I am
getting some strange errors mixed into an otherwise "complete" and working
database. So could my access installation itself have been corrupted in
some way?



"John Vinson" wrote in message
news:ag4u92lh2r2k5pcj0h4lcf5fci7evu4ej6@4ax.com...
> On Sun, 25 Jun 2006 17:47:02 -0400, "advance scout"
> wrote:
>
>
>>I do have a working version of the database from about two months ago. The
>>only thing that would have changed are the tables. so can I split the old
>>database ? and if so how do i do that?
>
> You're in luck. Back up this two-month old database AND your current
> database.
>
> I'd suggest manually doing the split, rather than using the splitter
> wizard.
>
> You can do so by doing the following steps:
>
> Take your working two-month old database (you DID back it up...
> right!?), take a deep breath, and delete all the tables. Compact it.
>
> Create a new, empty database. Be sure to set the Options so that Name
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
> Autocorrect is off (it's buggy). Then use File... Get External Data...
> Import and import all the tables (with the current up to date data)
> from your current database, the corrupt one. Compact this. Name it
> whatever you like, but if your database is named RALPH.MDB, you might
> want to name it RALPH_BE.MDB (_BE for Back End).
>
> Then open the database from which you deleted the tables, and use
> File... Get External Data... Link and link to the tables in this newly
> created database.
>
> John W. Vinson[MVP]

On Sun, 25 Jun 2006 21:12:21 -0400, "advance scout"
wrote:

>Thanks John.... BUT.... Something really weird is going on.... It seems
>that when I open the old database (remember it was not affected by the
>shutdown) i am getting weird errors there too- example the date() function
>is missing... all of my reports have question marks where that function is
>used... some other global errors too...

AHA...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

The bug can be triggered by the installation of other software
even if it's altogether unrelated to Access.

John W. Vinson[MVP]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12045