Monday, October 12, 2009

Repair Microsoft Access 2000 files

Sometimes, when you copy Access 2000 files (that have VBA in background) and attempt to open them on Access 2003 version, the files may not open. In addition, you might encounter an error message telling you to update your version of your MS Jet4.0. In such situations, if you need to access your Access 2000 files, then you will need to restore it from an updated backup. However, if in case, you have not maintained any backup or backup falls short to restore the desired files, then you will need to opt for advanced MS access repair application.

Consider a practical situation, where you installed MS Access 2003 on your new computer and copied your MS Access 2000 file (Employee) on it. However, when you attempt to open the file on your new system, you encounter the below error message:

“Microsoft Jet 4.0 Service Pack 8 or later must be installed to block unsafe expressions without affecting common functionality.”

However, when you attempt to attempt to download the identified update, you further encounter another error message:

“KB829558 SetUp Error
Setup has detected that the Service Pack version of this system is newer than the update you are applying...
There is no need to install this update “

The data stored in the Employee table becomes inaccessible after the above error message appear. TO access the records saved in the Employee table, you will need to set the Macro settings to low. To do so, you will need to follow the below steps:

Go to Tools and click on Macros.
Select Security option.
Change the settings to “Low”

However, if the problem persists, then there is a possibility that your Employee file has been damaged or corrupted. In such situations, you will need to repair the file using an inbuilt repair utility known as “Compact and Repair.” But, if the repair utility is unable to repair your corrupted file, then you will need to use powerful Access Recovery application to repair your corrupted file. Such access database repair tools use high end scanning methods to repair the corrupted Access database files (.accdb and .mdb). These utilities are easy-to-understand without any former technical knowledge.

No comments:

Post a Comment