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?
any ideas?
|
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 :) |