| With Microsoft Access 2007, you can open and | | | | The Access database is acting erratically as it has |
| use databases created in earlier version viz | | | | become corrupt. It could become corrupted owing |
| Microsoft Access 2000, 2002 and 2003. Moreover, | | | | to many reasons including abrupt system crashes, |
| you can also convert databases created with | | | | power fluctuations, application malfunctioning etc. |
| earlier previous versions of Access into the new | | | | Another reason could be simultaneous efforts to |
| Office Access 2007 file format. The conversion | | | | write or modify data at the same location by |
| or migration enable you to bank upon the new | | | | different users. |
| functionalities and features available in Access | | | | Resolution |
| 2007. At times, you might face problems with the | | | | The following steps will guide you in performing |
| converted database. The major problems are | | | | Access database recovery: |
| corruption and data inaccessibility. To tackle such | | | | Close the MS Access database file. If you are |
| issues, you must have a clean and updated | | | | compacting a shared Access database which is |
| backup copy of the database. However, if no | | | | located on a server or shared folder, make sure |
| backup is available, you do not have a better | | | | it is not opened by any other user. |
| option than grabbing a third-party Access | | | | In the Tools menu, locate Database Utilities, and |
| recovery software. | | | | click Compact and Repair Database option |
| Consider a scenario, wherein, you convert a | | | | Mention the name of the Access file you want to |
| database created with Microsoft Access 2003 to | | | | compact in the Database to Compact from dialog |
| 2007 format. It works fine for a good number of | | | | box and click Compact |
| days until you receive the following error | | | | Click Save |
| message: | | | | The original Access file gets replaced with the |
| "Microsoft Office Access has detected that this | | | | compacted version at the same location |
| database is in an inconsistent state, and will | | | | If you do not get the satisfactory results from |
| attempt to recover the database. During this | | | | using the inbuilt Compact and Repair utility, then |
| process, a backup copy of the database will be | | | | download an advanced Access recovery |
| made and all recovered objects will be placed in a | | | | software from the Internet. |
| new database. Access will then open a new | | | | For instant and best results, you can blindly trust |
| database. The names of objects that were not | | | | Stellar Phoenix Access Recovery. The application |
| successfully recovered will be logged in the | | | | is designed to help you repair corrupt MDB or |
| 'Recovery Errors' Table." | | | | ACCDB files. This risk-free application supports MS |
| In a multi-user environment, the affected | | | | Access 2007, 2003, 2002 and 2000 and recovers |
| database would become inaccessible to all the | | | | all database components including tables, forms, |
| users following this error message. | | | | reports etc. |
| Cause | | | | |