Tables in MS Access database (MDB file) have planned segregation of data in the form of columns and rows and serve as effective storage solutions for your data. Tables have separate cell which facilitate storing data separately.
But, when we talk about corruption, tables are no exception. Table corruption may occur due to a number of reasons like virus, system crash, improper system shutdown, and more.
Its corruption or damage may render all its data inaccessible. But, the data can be easily accessed and restored if you have an updated backup file. However, in case of unavailability of a backup file,one may access file repair using a third-party file repair tool.
Imagine a situation – Suppose, one day when you try to open a table in MDB file, an error message occurs that states:
“Record(s) cannot be read; no read permission on 'xxxx' (Error 3112)”
After this error pops up, the data stored in the table becomes inaccessible.
Reason:
This error may occur owing to the following reasons:
If you do not have required or necessary permissions to view the table or its data.
If the table or data stored inside the table is corrupted or damaged.
Solution:
Use any of the following measures to solve the issue:
In case you do not have permissions to view table's data, then you need to consult your administrator to change the permission settings.
In case the table object is corrupted or damaged, you should use an inbuilt utility present in MS Access, known as 'Compact and Repair' to repair the database table.
However, if this tool fails to perform its task, then use a powerful access database repair software to Repair MDB File and retrieve all the data stored inside it. These applications are abundantly available in the software market, but choosing the best out of them is a confusing and tedious task. Generally, the task of such software is to restore the file without overwriting its original contents and settings. In addition, you do not need any prior technical skills to perform repair as these applications are built with interactive user interface.
Access Recovery is an excellent repair software that resolves all issues of corruption related to MDB file(s). This MDB Repair software can repair database constraints including Primary Keys. It also repairs all database objects like tables, queries, etc and supports MS Access 2007, 2003, 2002, and 2000. This is a read-only software that works with Windows 7, Vista, XP, 2003, and 2000.
Resource Taken From :- http://hubpages.com/hub/Rectifying-MS-Access-Error-Records-cannot-be-read
