How To Recover Deleted Table From Access Database

How To Recover Deleted Table From Access Database

Have you lost or accidentally deleted your Access Database Table?  Looking for some easy ways to undo the deletion of records in Microsoft Access?

Don’t worry still you have the option to recover deleted Access database table. To know how it is to be done, you need to read this post very carefully.

As it contains complete information about MS Access Table recovery along with the best fixes to retrieve deleted MS Access tables.

Is The Recovery Of Deleted MS Access Table Is Possible?

Yes, the recovery of the deleted Access table is possible. Because when you delete a table/query in Access, they actually don’t get permanently deleted until Access is compacted using the compact and repair.

Though Access displays the object as deleted but still there is a possibility to reverse it back. When the Access Database items get flagged as ‘deleted’ Access renames them to ~TMPCLP##### (#=Number) or similar. So by default, the names of the items are lost.  Well in the jet database engine of MS Access version 2010/2013/2016, table names are usually recovered using the Unicode NameMap translation property of the table. 

Best Software To Retrieve Deleted Access Database Tables

To recover deleted Access Database tables, if you don’t want to get into the complexity of trying manual fixes then approach for some reliable third-party recovery tool. Even though there are several recovery tools available online, but I always suggest you all to go with the professional recommended software tool just like Access Repair And Recovery software.

This recovery software is particularly designed to repair corrupt/damaged Access database tables. It comes with a powerful algorithm that scans even severely corrupted Access database files(mdb/accdb). Moreover, it restores damaged or corrupt tables, queries, indexes, and other data.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

It also has a highly interactive GUI that helps users to easily operate and repair Access database without making changes in the original structure of the file. This tool can easily fix all minor and major database errors and problems of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on almost all versions of Windows operating system such as Windows 8/7/Vista/XP/2003. A free trial version is available that you can install to check the features and reliability of the software.

Steps To Fix Corrupted Microsoft Access Database Table

How To Recover Corrupt Access Database Table?

When Database corruption occurs, the first and foremost solution you need to try is manual fixes. You must try the following mentioned fixes to resolve Access Database Table Corruption. Here are some manual techniques to rectify database corruption.

Method 1: Restore Access Database Table Record

For the recovery of deleted MS Access table, you need to import the object from the backup into the database which contains the tables that you want to restore.

  • Firstly you need to open the database that you want to restore deleted Access database table.
  • To restore the missing table, that was; lost due to accidental deletion of the table, then skip to step 3. For replacing a table which contains corrupted data or the Access database stopped working suddenly, perform the following operation:
    1. To preserve the current object 
    2. Or to delete the object which you want to replace.
  • From the External Data tab, in Import group, tap to Access.

Import-Access-Database-1

  • From the Get External Data dialog box, tap to the Browse option to locate the backup database.
  • Tap to the Import tables, queries, forms, reports, macros, and modules into the current database, and then tap to the OK

Import Corrupt Database into new MS Access Database

  • In the Import Objects dialog box, hit the tab that corresponds to the type of object that you to restore.

Import-Access-Database-9

  • Tap to the object to select it.
  • If you want to restore more objects, repeat step number 6 and 7 until you have selected all the objects you want to restore.
  • You need to adjust the import options. In import Objects dialog box; click the Options button to review these options before importing your objects.
  • Finish selecting objects and setting options, click Ok to restore objects. 

Method 2# Use The Convert Database Option

If you have a copy of the database in the original format then use the Convert Database command. To do this, follow these steps:

Access 2000, Access 2002, or Access 2003

  • Make a backup copy of the original database.
  • Start Access 2000 or any later version.
  • Go to the Tool menu, click Database Utilities. 
  • Then tap to the Convert Database, and then click To Access 2000 File Format.

CONVERT ACCESS DATABASE

  • In the database to convert from the dialog box, click the database file name that you need to convert and then click to the Convert.
  • In the Convert Database Into dialog box, assign the new name of the database file, and then click to the Save.

Method 3# Repairing Access Database And Recovering Data

  1. Restore the database from backup file – that is why backups are very important.
  2. Delete .ldb file that is auto-created by jet database engine when the database is opened.
  3. Use the Jet Compact Utility that has been specifically designed to rectify minor corruption in the Access database.
  4. Remove all compiled VBA code from the database. This is done using the command line switch from Microsoft:

C:\Program Files\Microsoft Office\Office\MsAccess.exe /decompile

C:\DatabasePath\FileName.mdb

Note: 

Change the path shown above for MsAccess.exe if you installed it to a different location.

  1. You can also make use of the MS Access ‘Compact & Repair’built-in feature. Here are the steps to fix Access database corruption using this inbuilt feature.
    • Open MS Access and then go to the Database Tools-> Compact & Repair Database.
    • Select the corrupted file and click on Ok.
    • Then you will see the selected file will get rectified on completion of the process.

Method 4# Table Recovery From Datasheet View:

  • Firstly you need to make a copy of your damaged Access database table.
  • Either you re-create or just paste the structure of your damaged access database table into your new table.
  • After then open up your damaged Access database table and then copy the table structure so that both the tables appear similar to you.
  • Now go to your damaged Access database table. On the View menu, click Datasheet View. After then select the complete records of your old database by tapping to the record selectors which are blank buttons to the left of each record. On the Edit menu, click Copy option just to copy records from the damaged database table.

access datasheet view

  • Now go to the new table and put the pointer in a location that will keep the pointer in the same location as it located in the damaged database table. On the Edit menu, tap to the Paste option.
  • Make repetition of steps 4 through 6 using single records or small groups of records until you get an error message while testing only corrupted records that remain. If any data can’t be moved to a new table then re-type that data.
  • When all records is been moved to the new table, then you just have to make a new blank database in Access with different names other than the damaged database.
  • Now import your new database and all undamaged objects from damaged database tables into this new database. After then quit the
  • It’s time to rename the damaged database or move the damaged database into a new location. Delete .ldb file for the corrupted database if .ldb file exists and then shift the database to the location you want.
  • Now rename repaired database with the same name as of damaged database.

Wrap Up:

Hopefully, all the aforementioned solutions will help you in easy recovery of the corrupted/deleted/lost Access Database table. So, just try the above-mentioned manual fixes or automatic Access database repair solution. 

Do share your experiences with us in our comment section. if you are facing any other issue in your Access database then hesitate to ask, you can ask your queries on our social FB and Twitter social Account.

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Avatar

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.