View Full Version : Question automatic backup problem


bsc505
09-02-2008, 03:53 AM
so everytime i start my database it says its inconsistant and then automatic makes a backup copy. but when i go to the orginal it does it again and my switch board isnt poping up either?
any ideas?

KenHigg
09-02-2008, 03:55 AM
Have you tried compact & repair?

maxmangion
09-02-2008, 03:56 AM
Also try creating a new database and import all objects.

bsc505
09-02-2008, 03:56 AM
yea i tried it and it still messes up

bsc505
09-02-2008, 04:00 AM
ill try to import a new one though that might work
thanks

maxmangion
09-02-2008, 04:06 AM
if that also fails give it a try with the decompile.

1. Make a copy of your database
2. Compact
3. With Access closed, from a command prompt enter
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\My Documents\Database.mdb"
4.Compact again.

bsc505
09-02-2008, 04:19 AM
this is what it tells me " microsoft office access has detected that this database is in an inconsistent state, and will be placed in a new database. Access will then open the new database. The names of objects that were not successfully recovered will be logged in the "recovery errors" table"

KenHigg
09-02-2008, 04:21 AM
How large is the db? Can you post it?

bsc505
09-02-2008, 09:04 AM
thanks everyone i fixed it. What happend was a virus or someone deleted core tables and forms and i just re imported them and then compacted and repair and waloa.
thanks

KenHigg
09-02-2008, 09:08 AM
Cool - Glad you have it fixed. And thanks for sharing what you did. :)

maxmangion
09-02-2008, 09:08 AM
you're welcome, i'm glad that you sorted your problem :)