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.
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.
Error code: Access Runtime Error 3167
Error declaration: Record Is Deleted
Screenshot of the 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
- Hit the Save Database As > Back Up Database> Save As option.
- 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.
- Point the cursor to Info and then click on the Compact and Repair Database.
- Now in the Database to Compact From the dialog box, browse and select the database that you want to compact and repair.
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.
- 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.
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.
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.
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.
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.
Now you will successfully import all selected objects.
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.
This import Access database feature actually helps to import all the Access file objects like Tables, Forms, Reports, Queries, Macros, 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.
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
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.