{"id":149476,"date":"2023-09-20T11:12:35","date_gmt":"2023-09-20T11:12:35","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=149476"},"modified":"2026-03-02T07:00:07","modified_gmt":"2026-03-02T07:00:07","slug":"how-to-fix-access-runtime-error-7960","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-access-runtime-error-7960\/","title":{"rendered":"How to Fix Access Runtime Error 7960?"},"content":{"rendered":"
When working on a database file in MS Access, you may encounter the error 7960, preventing you from saving or editing the data. It usually occurs while opening the forms, reports, or other components of the database file. This error may also occur while working on the VBA code. There are different error messages related to this runtime error, such as:<\/p>
\n
Run-time-error 7960: There was an error compiling the function.<\/li>\n\n\n\n
Macro Single Step, with an Error Number 7960.<\/li>\n\n\n\n
7960: Failed to handle method call.<\/li>\n\n\n\n
Internal error: The Interpreter has already been closed.<\/li>\n\n\n\n
Error 7960: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.<\/li>\n<\/ul>
Common Error Messages Related to Access Runtime Error 7960<\/strong><\/h2>
The error 7960 usually occurs when the Microsoft Access database crashes or fails to respond for any reason. The error can occur due to different reasons. Some of the common causes are:<\/p>
\n
Incorrect queries or functions in VBA code.<\/li>\n\n\n\n
The data type is mismatched in the syntax or queries used in the code.<\/li>\n\n\n\n
Incorrect or corrupted queries.<\/li>\n\n\n\n
Invalid method or function properties.<\/li>\n\n\n\n
System is out of memory.<\/li>\n\n\n\n
The database file is corrupted.<\/li>\n\n\n\n
Trying to call a non-existing object.<\/li>\n\n\n\n
Missing tables or queries in database files.<\/li>\n\n\n\n
The database file is locked by another user (when using the Access database in multi-user environment).<\/li>\n\n\n\n
Issue with the form’s data source.<\/li>\n<\/ul>
Methods to Fix the Runtime Error 7960 in Access<\/strong><\/h2>
Sometimes, the Access macro error 7960 can occur when using a large-sized array with less available memory or storage. So, make sure there is enough storage space on the hard drive. You can optimize your VBA code to minimize memory usage or perform disk cleanup to free up some storage. If this did not fix the error, then follow the below troubleshooting methods:<\/p>
Method 1: Use Single Step Macro Option<\/strong><\/h3>
You can encounter the “Access VBA runtime error 7960 – There was an error compiling this function” when using the VBA code. It usually occurs when there is an issue with the macro you are trying to execute to perform a particular action in a form or report in the database. To troubleshoot this, you can use the Macro Single-Step option in Access. It helps you view the macro’s clear flow, including the actions’ results so that you can easily isolate the problematic action of the macro. To test the macro using the single-step macro option in Access, follow these steps:<\/p>
\n
In Microsoft Access, navigate to File.<\/strong> <\/li>\n\n\n\n
Click the Create<\/strong> option and then right-click on the Macro<\/strong> option.<\/li>\n<\/ul><\/figure>
\n
Now, click Design<\/strong> and then select the Single Step<\/strong> option.<\/li>\n<\/ul><\/figure>
\n
Click on the Run<\/strong> option.<\/li>\n<\/ul><\/figure>
\n
You will get a prompt to save the macro before executing. Save it by clicking on the Yes option.<\/li>\n<\/ul><\/figure>
\n
The Macro Single Step<\/strong> dialog box is displayed. You can see the information related to the macro, the macro action, and the error number.<\/li>\n\n\n\n
Click the Step<\/strong> option.<\/li>\n<\/ul>
Method 2: Check and Fix Missing References<\/strong><\/h3>
Sometimes, you can get the Access error 7960 due to missing references library in Access. It usually occurs when you use functions\/methods in your VBA code related to missing library components. To fix the error, you can check the missing references library in Access. Here’s how to do so:<\/p>
\n
Open Access VBA Editor.<\/li>\n\n\n\n
Go to Tools<\/strong> and then click the References<\/strong> option.<\/li>\n<\/ul><\/figure>
\n
In the References<\/strong> dialog box, check the list of available references and make sure all are selected. If any reference is not selected, then select it and click OK.<\/strong><\/li>\n<\/ul><\/figure>
Method 3: Check the VBA Code<\/strong><\/h3>
The Access error 7960 commonly occurs in VBA code when you try to use incorrect objects, functions, methods, property references, or SQL queries. It may also occur if you try to use non-existing reports or forms. You can review the VBA code and try to fix all the incorrect syntaxes or typos in the code. Follow the below steps:<\/p>
\n
Open the Access database in which you are getting the error.<\/li>\n\n\n\n
In the Access ribbon, click the Database Tools<\/strong> option and then click Visual Basic. <\/strong>The VBA Editor is displayed.<\/li>\n<\/ul><\/figure>
\n
The Project Explorer<\/strong> displays all the objects, including modules, database names, form names, reports, etc.<\/li>\n\n\n\n
You can click on any object to view the code associated with it. Check all the queries and syntaxes, and make changes if required.<\/li>\n<\/ul>
Method 4: Check the Form Record Source Properties<\/strong><\/h3>
The Access error 7960 can also occur if the Microsoft Access application fails to read the form or other objects in the code due to incorrect form record source property settings. In Access Form, record source property refers to the data source property associated with the form. If for any reason, there is a mismatch between the form record source property name and the name of the object used in the query, you may experience an error. You can check the Access form’s record source property settings by opening the form in Design View<\/strong>. Then, check if the record source setting is pointing to the correct form in the Property Sheet window<\/strong>.<\/p>
Method 5: Close Conflicting Applications<\/strong><\/h3>
You can experience the Access error 7960 if there is any conflict between Access and other applications. You can check and close the conflicting applications via the Task Manager. Here’s how to do so:<\/p>
\n
Press Ctrl+Alt+Del simultaneously.<\/li>\n\n\n\n
Select the Task Manager<\/strong> option.<\/li>\n\n\n\n
In the Task Manager <\/strong>dialog box, click Processes<\/strong>.<\/li>\n\n\n\n
You will see a list of currently running applications on your system.<\/li>\n\n\n\n
Recognize the problematic program, click on it, and then click the End Task<\/strong> option.<\/li>\n<\/ul>
Method 7: Re-register Windows Registry<\/strong><\/h3>
Re-registering the Windows registry can also help fix the error 7960 in Access. It is a basic troubleshooting method to fix the corrupted DLL files. This method usually works if there are missing registry entries related to the Microsoft Access application. You can use the Regedit.exe to overwrite the default settings.<\/p>
Method 8: Check and Reinstall Microsoft .NET Framework<\/strong><\/h3>
The .NET Framework plays a primary role in running Visual Basic applications in Access. Sometimes, issues in the redistributable framework can also cause the VBA runtime error. You can check and reinstall the latest Microsoft .NET Framework to fix the issue.<\/p>
Corrupted queries, macros, forms, tables, and other components in the Access database file can also cause the Access error 7960. You can use the Compact and Repair tool in MS Access to repair the damaged or corrupted database file. Here’s the procedure to do so:<\/p>
\n
First, ensure the database file is closed (in which you are getting the error).<\/li>\n\n\n\n
Then, open your Access application.<\/li>\n\n\n\n
Go to the Templates<\/strong> page and then click Blank Database<\/strong>. <\/li>\n\n\n\n
Select File<\/strong> and then select Close.<\/strong><\/li>\n\n\n\n
Now, navigate to Database Tools<\/strong> and then click Compact and Repair<\/strong> Database<\/strong>.<\/li>\n\n\n\n
Select the affected database in the Database to Compact From<\/strong> dialog box.<\/li>\n\n\n\n
Select the Compact <\/strong>option.<\/li>\n\n\n\n
You will find the compacted and repaired database at the exact location where you actually stored the database file.<\/li>\n<\/ul>
![\"Microsoft](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/click-create-and-then-macro-option.jpg\")
<\/figure>![\"Microsoft](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/click-design-and-then-click-single-step-option.jpg\")
<\/figure>![\"Clicking](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/click-run-tab.jpg\")
<\/figure>![\"Prompt](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/click-yes-on-saving-mesage.jpg\")
<\/figure>![\"Access](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/click-tools-and-then-click-references.jpg\")
<\/figure>![\"Checking](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/check-the-list-of-available-references.jpg\")
<\/figure>![\"Opening](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/09\/click-database-tools-and-then-click-visual-basic.jpg\")
<\/figure>