It’s not a very healthy sign when "The database is in an unexpected state" error message flashes on the screen. You don’t remember having done anything wrong so as to instigate the occurrence of this error.
All you did was convert a number of Access 95 databases to Access 2000 on Windows NT by using the DAO Compact Database method instead of the Convert Database command on the Tools menu and this error pops up. The databases were created in microsoft Access 95 or an earlier version by using the Compact Database method and the new turn of events has left the new databases in a partially converted state.
This error makes its appearance when attempts are made to open the database in Microsoft Access 2000 or later versions.
If you still have a copy of the database in it original format, use the Convert Database command on the Tools menu (Database Utilities submenu) to convert it.
If the original database in its original format is no longer available, try creating a new database and import your tables and queries to preserve the status of your data. Try importing one object at a time as this will enable you to ascertain if it’s a single object that’s creating the trouble. If you hit upon the specific object, step over it and continue importing but in most cases it happens otherwise and you are not able to import the tables and the objects become irrecoverable. Such a behavior clearly points towards database corruption and needs immediate attention.
If you are still short of facing this situation, follow these tips religiously to stall chances of impending corruption.
• Improper shutdown or abruptly terminating Access breeds corruption
• Canceling the job using the Task Manager or powering off the system without attempting a proper shutdown facilitates corruption
• Strangely enough, cordless phones, radio transmitters, welding machines near and around the computers create database corruption.
• Split the database into front-end/back-end arrangement. You are begging for corruption to set in cause if your access database is placed on a shared drive, one instance of network glitch can cause it to corrupt. Use the Access wizard for this purpose under Tools>>Utilities
• Place the front-end on each user’s desktop and link to the tables in the back-end via a UNC path to the location on the server it resides in.
• Try using the Compact and Repair function provided in Access on a regular basis. Access Repair is an excellent utility that serves the dual purpose of enhancing the performance of the application and invalidating corruption.
If you follow these simple rules, you can be rest assured that your database would perform as efficiently as ever but if you deviate from the given rules and use your database carelessly, you are bound to face corruption and eventual data loss which will obviously take a toll on your finances and health.
If you are already suffering from a database corruption that has rendered your
data inaccessible, consult a reliable data recovery company immediately cause it is impossible to recreate the crucial data that has been developed over years and thus data recovery from these inaccessible database files becomes mandatory.
Stellar Phoenix Access Recovery software effectively repairs and restores the corrupted access database. It is equipped to deal with any problems that might entail repair of any of the components of the Access database including tables, forms, reports, queries and macros.

John Martin a student of Mass Communication doing research on data recovery software. He is also a freelancer for www.stellarinfo.com

Article Source: http://www.therealarticles.com

Please Rate The Above Article From The Data Recovery Category

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated

Click the XML Icon Above to Receive Data Recovery Articles Via RSS!