Whenever we are working over a damaged database on Windows, we encounter some common MS Access database error messages & error codes, which needs to be fixed:
- Access Error 3343: “Unrecognized database format ‘filename.mdb’.”
- Access Error 3011: “The Microsoft Jet database engine could not find the object ‘MySysObjects’. Make sure the object exists and that you spell its name and the path name correctly.”
- Access Error 3112: “Record(s) cannot be read; no read permission on ‘MySysObjects’.”
- Access Error 9505: “Microsoft Access has detected that this database is in an inconsistent state, and 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 objects that were not successfully recovered will be logged in the “Recovery Errors” table.”
WHY Access Database Error occurs:
The core problem of these Access errors is the “MDB File” and “ACCDB File”. MDB File stands out for “Microsoft Database File” and it has “.mdf” extension which helps us to identify it. This format was used in the earlier version of MS Access (till 2003) and the newer versions come with ACCDB format.
MDB File contains tables, DB queries and a lot that can be used to link to and fetch data from other files, like HTML and XML, and applications, like Excel. Data is stored in continuous pages, if any of the pages is lost or data is corrupted then it will bring out a database error(s). Believe me, these errors are literally irritating.
You Might Like:
How to Fix Access Database error:
To tackle these annoying Access database error, there are various methods, some are provided inside the MS Access. One can easily go through them and sought out these errors. Some methods are as follow:
1. Compact and Repair Database option:
As the Access Database grows in size it creates issues so, for handling these errors, Access got an inbuilt option, which is the Compact and Repair tool.
- Run MS Access.
- Go to File menu and choose Info.
- Select Compact and Repair.
- Choose the mdf or accdb file to be repaired.
- Ta Da, You are good to go.
2. By Manually exporting elements:
Another solution could be, by manually exporting elements (Tables, forms, queries etc.) of access database to another new database.
- Open MS Access.
- Choose External Data tab and choose More and click on Access Database.
- Provide the destination in the File Name box and tap ok.
- A dialog box will appear having name Export. Facilitate a new name for the element that you are transferring and then click ok.
3. By Editing Windows Registry:
I will recommend the below manual only if you are an advanced user.
- Go on Start and search for regedit.
- Registry Editor will flash on your screen.
- Select MS Access Key.
- Open File menu and choose Export.
- Choose Destination folder from Save in list.
- Provide Backup File name and preferred branch in Export range box.
- Press Save.
4. Count on automated Tools:
In case, if you are not able to fix Database error(s) using DIY’s then go for tools available in the market. After doing some comparisons and research, I’ve found the “MS Access Recovery Tool”. It can help you out in various ways like in repairing mdf and accdb files, Big size OLE and MEMO data files to be recover, etc. You can easily rely on it.
After using these DIY’s, there is a chance that you can find the solution to your problem and if not able then you can go for the tool also. So this was the ”Common Microsoft Access Database Errors and their Solutions”.