MS Access uses the MS Jet (Joint Engine Technology) Database Engine to manage the commands to operate the Access database. It stores all the database data in an MDB (Master Database) file. Also, it offers the user interface to monitor and maintain Access MDB file. However, there are times when you are not able to use the Jet engine to perform various tasks such as compacting the database. Such problems may arise due to MDB file corruption. In such cases, you should use appropriate corrective measures to repair MDB file. If you are not able to repair MDB file, then you should use a third-party MDB file repair software to do the needful.
Consider a scenario wherein you are working on an Access database. You use Jetcomp.exe to compact the database, it fails to do so. An error message is displayed, that is:
“Records can't be read, no read permissions on MyDatabase.”
Cause:
The root cause of this error is that the database is either corrupted or damaged. Due to which, the MDB file is inaccessible.
Resolution:
To resolve this error and repair MDB file, you should perform the following steps:
Consider a scenario wherein you are working on an Access database. You use Jetcomp.exe to compact the database, it fails to do so. An error message is displayed, that is:
“Records can't be read, no read permissions on MyDatabase.”
Cause:
The root cause of this error is that the database is either corrupted or damaged. Due to which, the MDB file is inaccessible.
Resolution:
To resolve this error and repair MDB file, you should perform the following steps:
- Create a database having the structure of the problem database.
- Paste the structure of the problem database to a new table.
- Copy the table structure of the problem database table.
- Open problem database table and click 'Datasheet View' on the 'View' menu and select all records.
- Copy all the records from the problem database table.
- Now, paste the records in the new table.
- Follow these steps for all the remaining records in the rest of the tables.
- Create a new database with a different name.
- Import the new table to the new database.
- Exit MS Access 2003.
- Delete the LDB file of the problem database.
- Rename the new database as the problem database. Now try to open the database again. The problem should be resolved now.
However, if you still facing difficulties in opening the database table then you should use a third-party MDB file repair software to recover the inaccessible data. Such MDB repair tools are read-only in nature that do not overwrite the existing database while scanning it.
No comments:
Post a Comment