{"id":6733,"date":"2017-05-31T07:15:00","date_gmt":"2017-05-31T07:15:00","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=6733"},"modified":"2025-11-03T17:18:41","modified_gmt":"2025-11-03T17:18:41","slug":"how-to-fix-ms-access-database-error-2950","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-ms-access-database-error-2950\/","title":{"rendered":"How to Fix the MS Access Error 2950?"},"content":{"rendered":"
Macros are used in MS Access to automate tasks and add functionality to reports, forms, and controls in Access database files. While executing macros, you may encounter an error, saying Action failed – Error Number 2950. This error usually occurs when the application fails to read the macros and other objects in the database. Various factors can lead to this VBA error. Let’s understand the causes behind this VBA error and see how to fix it.<\/p>
Reasons for the MS Access Error 2950<\/h2>
Below are some common reasons that can trigger this error in MS Access:<\/p>
\n
When MS Access does not trust the database location.<\/li>\n\n\n\n
When trying to open the database which is in the disabled mode.<\/li>\n\n\n\n
When Macro Settings are disabled.<\/li>\n\n\n\n
If macros are corrupted.<\/li>\n\n\n\n
If the Access DDE refresh option is disabled<\/li>\n\n\n\n
If the Access database is damaged or corrupted.<\/li>\n\n\n\n
If there are incorrect or invalid queries in the VBA code.<\/li>\n<\/ul>
Methods to Troubleshoot the MS Access Error 2950<\/h2>
Follow the solutions given below to troubleshoot and resolve the Access database error 2950.<\/p>
Method 1 – Enable the Database for the Current Session<\/h3>
You can get the Access error 2950 if the macros have been blocked. In such a case, you get an alert message with the option to enable content for this session. When you select this option, it allows you to run the macros temporarily (for the current session). <\/p>
To enable the database for the current database, follow the below steps:<\/h4>
\n
Open your affected Access database. <\/li>\n\n\n\n
On the ‘Security Warning’ message bar, click on Options.<\/li>\n\n\n\n
When ‘MS Office Security Options’ dialog box opens, select “Enable content for this session” and then click OK.<\/li>\n<\/ul><\/figure>
Note:<\/strong> Repeat these steps each time when you open the database.<\/p>
Method 2 – Move the Database to a Trusted Location<\/h3>
You can experience the “Access Error 2950” if the database is not located at a trusted location. You can try moving the database to a trusted location. <\/p>
Follow the given steps:<\/h4>
\n
In MS Access, click the File <\/strong>tab and then select Options.<\/strong><\/li>\n<\/ul><\/figure>
\n
From the ‘Access Options’ dialog box, select Trust Center > Trust Center Settings<\/strong>.<\/li>\n<\/ul><\/figure>
\n
Click Trusted Locations and then do any of the following:\n
\n
Note paths of the trusted locations listed under ‘User Locations’.<\/li>\n\n\n\n
Add a new trusted location. For this, click on Add new location and then specify the path of the location that you want to add.<\/li>\n<\/ul>\n<\/li>\n<\/ul><\/figure>
Once you have the trusted locations, move the Access database to any one of them.<\/p>
Method 3 – Check and Enable all Macros (If not enabled)<\/h3>
The Error 2950 in MS Access can also occur if the Macro Settings are disabled. You can check and enable the macros by following these steps:<\/p>
\n
Open your Access application.<\/li>\n\n\n\n
Go to File <\/strong>and then click Options.<\/strong><\/li>\n\n\n\n
Click on the Trust Center<\/strong> option and then select Trust Center Settings<\/strong>.<\/li>\n\n\n\n
In the Trust Center <\/strong>window, click Macro Settings.<\/strong><\/li>\n\n\n\n
Under Macro Settings<\/strong>, you will see these options:<\/li>\n\n\n\n
Disable all macros without modification<\/li>\n\n\n\n
Disable all macros with modification.<\/li>\n\n\n\n
Disable all macros except digitally signed macros.<\/li>\n\n\n\n
Enable all macros.<\/li>\n<\/ul>
Verify whether the “Enable all macros<\/strong>” option is selected or not. If not, then select it and click OK.<\/strong><\/p><\/figure>
Method 4 – Check and Enable Access DDE Refresh Option<\/h3>
You can experience the Access error 2950 if the Access DDE Refresh option is not enabled. If this option is disabled, it can block the macros and Dynamic Database Exchange (DDE) links on the database. You can check the Access option for Dynamic Database Exchange (DDE) and enable it. <\/p>
To do so, follow the below steps:<\/h4>
\n
Open your Access database.<\/li>\n\n\n\n
Click File <\/strong>and then Options<\/strong>.<\/li>\n\n\n\n
In the Access Options window, click Client Settings.<\/strong><\/li>\n<\/ul>
Under the Advanced <\/strong>section, check if the Enable DDE refresh<\/strong> option is selected. If not, then select it and click OK.<\/strong><\/p><\/figure>
Enabling the DDE refresh option in Access allows execution of the macros actions and DDE operations, thus help in resolving the Access error 2950.<\/p>
Method 5 – Check VBA Code<\/h3>
Many Access users have reported the Access error 2950 while using the Validation Rule property and the Validation properties in the VBA code. It usually occurs if you have used macros in the code to enforce certain validation rules. Make sure you’re using the validation properties correctly in the code. <\/p>
To check the VBA code, follow these steps:<\/h4>
\n
In the Access database, go to the Database Tools <\/strong>tab.<\/li>\n\n\n\n
Click on Visual Basic.<\/strong><\/li>\n<\/ul><\/figure>
\n
In the Visual Basic Editor<\/strong>, check the VBA code.<\/li>\n\n\n\n
Check the syntaxes of properties, methods, etc. used in the macros. If anything is incorrect, correct it.<\/li>\n<\/ul>
Method 6 – Repair your Access Database<\/h3>
Corruption in the Access database can alter or damage the code embedded in it, which can lead to the Access error 2950. If you suspect corruption in the database is behind the error, then you can repair it using the built-in utility in MS Access – Compact and Repair. <\/p>
To use this utility, follow the steps mentioned below:<\/h4>
\n
Open the affected Access database file.<\/li>\n\n\n\n
![\"microsoft](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/microsoft-office-security-option.png\")
<\/figure>![\"Click](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Access-Options.png\")
<\/figure>![\"Trust](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/MS-Access-Trust-Center-Settings.png\")
<\/figure>![\"Select](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Select-Trusted-Locations.jpg\")
<\/figure>![\"Enable](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Macro-Settings.png\")
<\/figure>![\"Enable](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Enable-DDE-Refresh-in-Access-Options.png\")
<\/figure>![\"Database](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Database-Tools-tab-in-MS-Access-1024x117.png\")
<\/figure>