In this article, we look at ways of dealing with error 3112 in MS Access.
Despite improvement in software development over the years, there are hardly any commercial applications out there which are completely free from errors or flaws. It is natural to come across errors when working on computer applications, but what is more important is to secure your data from these errors so that they do not create greater damage to you. Errors can occur anytime, so we need to make sure that in case of an error we not only keep our data safe but also have a way of dealing with the error.
MS Access error 3112
When working on MS Access and trying to access an MDB/ACCDB file, you might have come across an error “Record(s) cannot be read; no read permission on ‘….’ ”. The main reason why this error occurs is that the files you are trying to access are corrupted! How and why those files got corrupted is a different issue you should look into, but today we will deal with these files which have already been corrupted and are not being accessed.
Apart from accessing corrupted files, you may also come across error code 3112 if you are trying to access a file for which you do not have the required amount of permissions.
Fixes for error 3112 in MS Access
If the cause of the error is a lack of sufficient permissions, then you need to ask the system administrator or the object creator to provide you with permissions. However, if the corruption of database is causing the problem, then you should try out the following fixes.
Using compact and repair utility
One of the very first things to do should be to use the inbuilt tool in MS Access for repairing a corrupt database. If this does not work, you can try out other solutions.
Import database objects
You can opt for importing items from an old database to a new database, to make sure that you are able to access it. You might opt for importing them one by one, or by using the import wizard. Once you have completed the import process, you will also have to re-create all relationships that existed in the old database.
Exporting to ASCII file
If none of the above solutions worked for you, maybe you can give these a try:
- Export your table to an ASCII file.
- Delete the table and all its associated relationships.
- Examine ASCII file in the word processor and remove all the bad data that is present.
- Import this updated ASCII file to a newly created table.
- Insert the records that were deleted forcefully.
Recover from Backup
If there is a recent, valid, and secure backup available with you, there is probably no need to repair the corrupted file. You can opt for recovering your files from backup to see if you get access to files.
Using Specialized Recovery tools
This can be the last thing to try out. If all the above solutions fail to provide you recovery to database or access to inaccessible files, you might want to take help of a specialized accdb recovery tool like DataNumen Access Repair to deal with the damaged Access database.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql repair and excel recovery software products. For more information visit www.datanumen.com