5 Ways To Fix Access Runtime Error 3167: Record Is Deleted

5 Ways To Fix Access Runtime Error 3167: Record Is Deleted

Does your Access database frequently show the Runtime Error 3167 record is deleted? Looking forward to the fixes on how to resolve this specific Access Runtime Error 3167?

But before diving into the fixes, catch more detail about this MS Access 3167 error: record is deleted.

User’s Query:

I’m attempting to run an append query to a linked table (access backend) and I’m getting Error 3167, Record is deleted. I can’t seem to find the offending record. But if I change the table to a local table and run the append query, it runs with no problems at all. I’ve attempted a compact and repair but it’s not helped at all.

Any ideas?

Source: https://stackoverflow.com/questions/50093186/error-3167-record-is-deleted-when-running-an-append-query-access-2010

Error Detail:

Error code: Access Runtime Error 3167

Error declaration: Record Is Deleted

Screenshot of the error: 

Access record is deleted error

What Are The Reasons For Getting Access Error 3167 Record Is Deleted?

Following are some root causes of the Access Record is deleted error.

  • Hardware failure or occurrence of some issue
  • Software confliction
  • Accidental deletion of Access database records
  • Retrieving data from an out-dated backup

How To Fix Access Database Error 3167 Record Is Deleted?

Method 1# Recover From Access Database Backup Copy

It is the best way to overcome this record is deleted error without putting any kind of effort. The only thing you need is that you should have a proper backup.

If till now you haven’t made such approach then do this immediately. As it is very helpful for handling any type of Access data loss situation.

For creating Access database backup, follow the below-outlined steps:

  • Open your Access database first of which you want to keep backup.
  • Now go to the File> Save As

Prevent Missing/ Disappearing Of Access Database File Data

  • Hit the Save Database As > Back Up DatabaseSave As option.

Prevent Missing/ Disappearing Of Access Database File Data 2

  • Assign all the necessary detail and then hit the Save button.

Method 2# Compact and Repair

With the passage of time, the chances of Access database file size inflation and corruption get high. So the reason behind the occurrence of this Access record is deleted error can be due to the oversizing of database.

In such a situation, MS Access inbuilt tool: compact and repair work amazing. The name of this inbuilt utility tool itself clarifies that it compresses and repairs the database.

Let’s know how to compact and repair Access database:

Open Access, but do not open the database. Click on File.

how_to_compact_and_repair_a_database_manually_in_access_2016

  •  Point the cursor to Info and then click on the Compact and Repair Database.

how_to_compact_and_repair_a_database_manually_in_access_2016

  • Now in the Database to Compact From the dialog box, browse and select the database that you want to compact and repair.

compact and repair 5

Note: Make sure that nobody is using the database file, or else the compact and repair Access database utility will fail.

If this Compact and Repair tool fails to work and you are still getting the same Access 3167 error then check the next method.

Method 3# Repair Access Database Record From The Command Line

below here is the steps to repair corrupt Access database from Command-Line. Perform these steps very carefully otherwise, this will originate some more problems in your database.

  • In the Start menu Search box type the “command” or “cmd”.

  • Make a right-click over the Command Prompt icon and then choose the Run as administrator option.

Repair Access Database From Command Line

  • In the opened window of command prompt or Command Line application, just type the following command:

msaccess <path to database file >\<database file name> /compact

Note: in the above-mentioned command you need to enter the actual Access database file path and name for your database file respectively.

Method 4# Import Corrupt Access Database into a New One

The second most opted solution to repair Access Database is importing data from corrupt Access Database to the new one. Though this step doesn’t repair up your corrupt Access Database one can easily perform Access database recovery with this. So, here are the following steps that you need to follow.

Step 1: At first, open Microsoft Access on your PC.

Step 2: On the right-hand side pane, tap the option of “create new database” files. Assign a name for the file and choose the location. Tap the Create option to create a new database.

Step 3: This will make a database file and open it up in the Microsoft Access program. Click the external data at the top.

Import-Access-Database-1

Step 4: To import the Access database tap the Access option.

Step 5: You will see a get external data Access Database window is get opened on your screen.

 On this opened window tap the Browse option to make a selection for the file that you want to import.

Step 6:

On the opened dialog box of File Open, browse access database files and select them by clicking. Tap the Open option to make confirmation for the selected items.

Step 7:

In the edit box, you can easily take a look at the selected files. For further continuing of the process tap to the OK option.

Step 8:

On Import objects dialogue box, choose the objects that you want to import from the selected Access database files. After the selection of the objects, tap to the OK option.

Import-Access-Database-9

Step 9:

Now you will successfully import all selected objects.

 Step 10:

If you want to save the above-performed import steps for future work then check the Save import steps box. At last tap to the Close option.

Note:

This import Access database feature actually helps to import all the Access file objects like TablesFormsReportsQueriesMacros, and Modules from corrupted Access Database to a new file.

Method 4# Use The Reliable Recovery Tool To Recover Deleted Access Records

If you don’t want to take risk of data loss or looking for a reliable solution then go with the professional recommended solution i.e Access Database Repair & Recovery Tool.

As this tool easily recover deleted records from the corrupted Access database ACCDB/ MDB file. The only thing you need to do is just download and install this Access Repair & Recovery tool.

* 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.

Some impressive features of this tool are listed here so take a look over it:

  • Recover permanently deleted records.
  • Retrieve the complete database table.
  • Easily retrieves password-protected forms and modules.
  • Preview feature to view recovered files.
  • The software works for entire versions of Access database including 2019, 2016, 2013, 2010, 2007, 2003, 2002, and 2000 installed on Windows 10, 8.1, 8, 7, Vista, 2003, and XP versions.

Steps To Use Access Database Repair Freeware Tool

Wrap Up:

Through this blog post, I have tried my best to share all the detail regarding this specific Access runtime error 3167: record is deleted. If the above-listed manual method fails to solve this record is deleted mystery and anyhow you need to recover deleted Access records then approach the software tool.

If anyone of you having some more ideas to fix this Access error code 3167 then do share with us.

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.