Easy Steps to Repair Damaged Access Database Table




Easy Steps to Repair Damaged Access Database Table

Microsoft Access is a relational database management system that is usually included in your Microsoft Office suite. However, it is not a very well versed database management system like MySQL, but it too is used largely to overcome the limitations that you encounter while handling huge amount of data in MS Excel. Apart from this, MS Access too contains data and database objects like tables, queries, forms, modules, and macros.

Just like any other database, the database files created in MS Access too, at times, get corrupt and render corruption errors when you perform some activity in it.

The corruption errors in MS Access database are generally seen when you run a query, or report, or form, or delete a record. In such situations, you may encounter both or one of the following error messages:

“Jet has stopped the process because you and another user attempted to change the same data at the same time.”

You may face the following error message when you use Jetcomp.exe to compact your database:

“Records can’t be read, no read permissions on MyDatabase.”

In this error message the MyDatabase is the name of your database.

Moreover, you can open a damaged database table and view its contents, but you cannot export it to another database as well as import it from other database. However, you can try below mentioned steps to recover data from damaged database table, but before that it is suggested to make a copy of your database table.

Create a copy of your damaged database table
Paste or recreate the structure only of the damaged database table to this new table.
Open the copy of the structure that you have created along with the damaged database table in a way that you can see both.
Go to the damaged database table, select ‘View’ menu and click ‘Datasheet View’ and then select entire record by clicking the record selector that are available at the left of each record. Now go to ‘Edit’ menu and click ‘Copy’ to copy all the records from damaged database table.
Go to the new table and point to the location in this table where the data is located on the damaged table. After that go to ‘Edit’ menu and click ‘Paste’.
Test this new table after performing every copy and paste operation.
Repeat Step 4 to 6 for each record or group of records present in the damaged database until you get an error message while testing. Now retype the records that you cannot move to the new table.
Create a new blank database with a different name than this damaged database after the completion of the moving of all the records to the new table.
Now import the new table that you have created and all the undamaged records to this new database and quit Access.
Rename the damaged database as well or move it to some other location.
Rename the newly created database with the name of the damaged database.

However, if these steps fail to rectify your issue with MS Access database, then use of a professional Access database repair software is recommended. Professional Access database repair tool repairs corrupt or damaged Access database file without much hassle and recovers your entire data stored in it.

Tags: ,

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]