Problem: I designed a small access database and created tables and relationship between them. The database works fine and have no problem. I have stored the database in My Documents on my hard disk but the moment I put it in a folder on the shared network it does not work. The database will open fine 3 or 4 times but 5th time I try to open it will give an error message.
Error message: Microsoft Office has detected that this database is in inconsistent state and this database will attempt to recover the database. During this process a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database. The names of the objects that were not successfully recovered will be logged in the ?Recovery Errors? table.
If I click OK for recovery sometimes it recovers the database but sometimes it gives the error message:
?The database can?t be repaired or is not a Microsoft office access database file.?
As a result I loose the database.
I have been trying to find the reason for these errors but no luck.
Can I directly copy or paste the database from my documents to shared network drive. Because what I have been doing so far is saving a backup copy of the database from my document on to the shared network drive. Is this method correct? Or do I need to follow a proper procedure? Do I need to make an ODBC connection?