By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,676 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,676 IT Pros & Developers. It's quick & easy.

Access Database

P: 1
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?
Oct 24 '07 #1
Share this Question
Share on Google+
1 Reply


numberwhun
Expert Mod 2.5K+
P: 3,503
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?
You have posted a question on a specific topic in a forum designed for Introductions. I am moving this post to the Access forum.

In the future, please post all questions in a forum appropriate to the topic.

Regards,

-Moderator
Oct 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.