How to Fix Access “Data Cannot Be Inserted Because There Is No Matching Record” Error?

Suppose, you’re working on an important Access database, and suddenly you hit a wall: “Data cannot be inserted because there is no matching record.” Frustrating, right? Well, it is important to understand this error for maintaining a smooth and efficient database system. So, let’s dive into what causes this peculiar error and how to fix it in no time with less effort.

Screenshot of the error:

Something About Data Cannot Be Inserted Error:

Access error data cannot be inserted because there is no matching record occurs when trying to add data to a specific field in the database. You may also receive this error when attempting to create another field in the same database record list.

However, a wide variety of reasons can lead to this warning message, including:

1. Missing primary key values
2. Improper foreign key references within DB records
3. Corrupted database file
4. Incorrect ‘Record Source’ property settings
5. Data entry errors

As you have known the common causes, now it’s time to know the possible solutions to troubleshoot this problem.

Methods to Fix MS Access Data Cannot Be Inserted Because There Is No Matching Record Error

Follow the below advanced techniques for handling Access error data cannot be inserted because there is no matching record:

Method 1- Restore from Backup

Restoring from backup is the primary solution to fix Access-related errors and issues without any trouble. So, if you have created a backup of your DB file that is showing the error, you can restore it from the backup file. In case, if you don’t have a backup, you can follow the solutions discussed below.

Also Read: Microsoft Access Can’t Append All the Records in The Append Query- Don’t Skip!

Method 2- Check & Change ‘Record Source’ Property

Many times, it happens that if you have set the Record Source property incorrectly, then also you can receive data cannot be inserted because there is no matching record SharePoint Access error.

Note: The Record Source property in Access holds the source data for the form/reports of the database.

To solve this, you have to check and ensure the record source property is pointing to the right side table or query. For this, you have to follow the below steps:

• Open the DB file in a design view.
• Under the Property Sheet, you have to click Data tab.
• Now, click on a dropdown corresponding to Record Source & check whether it’s set to a correct table. If it’s incorrect, change it.

Method 3- Import Corrupt Database Data into a New One

Another effective trick that can assist you in dealing with this issue is importing the entire data from a corrupted database to a new DB file.

Here are the comprehensive steps to do so:

• Open MS Access.
• Select a Blank Access Database then click OK.
• After that, enter a name for your new DB file & choose a location to save it.
• Next, click on Create option >> File tab >> Get External Data >>Import.
• To import the Access database >> click on Access option.

• Then, you will get an external data Access Database window opened.
• Now, go to Tables tab at the top of the Import Object Window then click on Select All >> OK.

Method 4- Fix Data Cannot Be Inserted Because There Is No Matching Record Error by Changing Macro Security

There is no matching record error can arise if macros are disabled in the Macro Security settings. To overcome this situation, you can try changing the macro settings by following the below steps:

• Open the faulty Access database, click File > Options > Trust Center.
• In the Trust Center, you have to click on Trust Center Settings >> Macro Settings.

• Choose “Enable all macros” and then click OK.

That’s it.

Also Read: Fixes for Access the Search Key Was Not Found in Any Record Error

Method 5- How to Repair Corrupt Access Database?

If the above solutions fail to work, it simply means your Access database is experiencing a corruption issue. In such a case, you can use the MS Access built-in feature “Compact and Repair.” This utility can eventually help you to repair the corrupted database for free.

Here is how you can run this tool:

• Open your MS Access database.
• Go to File >> Info option >> click Compact & Repair Database.

However, a Compact and Repair feature may fail to work if the file is severely corrupted. In such a case, you can opt for the most recommended Access Repair Software. This program is specially designed to solve various Access errors & issues triggered by corrupt DB files. It supports Windows 11, 10, 8.1, 8, or 7 systems.

The best part about this tool is- you can download its free trial version to scan corrupted Access database (.accdb/.mdb) files & preview their recoverable components.

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

Steps to Use This Tool:

access-repair-main-screen

access-select-database

access-repairing

access-repairing-completed

access-preview

access-save-location

access-saving

Related FAQs:

Can Data Be Inserted Updated and Deleted in Your Database Using a Dash Object?

No, data cannot be inserted, updated, and deleted from a DB table by using a Dash Object, it can be done by using a Form object in Access.

How to Fix Type Mismatch Error in Access?

You can fix type mismatch error in Access by checking the incorrect syntaxes or verifying the joined fields in your queries.

Which Command Is Used for Inserting Records?

The INSERT INTO command is used to insert new records in the database table.

How Do You Insert Records in Microsoft Access?

To insert records in Microsoft Access, follow these steps:

• Launch a table in Datasheet View or a form in Form View.
• Go to Home tab, under the Records group, you have to click on New or New (blank) record.
• Now, enter your new data.

Also Read: Fix Run-Time Error 3047- Record Is Too Large Access?

Wrapping Up

Understanding and fixing the data cannot be inserted because there is no matching record SharePoint Access error is crucial for maintaining a healthy database. However, by extracting the major factors and implementing the effective solutions mentioned in this blog, you can solve this error and keep your database running smoothly.

In addition, you can reach us on Facebook and Twitter for any guidance or support.

Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
2. Click Browse and Search option to locate corrupt Access database.
3. Click Repair button to repair & preview the database objects.

Pearson Willey

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.