How to Fix MS Access Database Error 2950?

Microsoft Access is a Database Management System that combines the capabilities of Microsoft Relational Database Jet Engine with a convenient graphical user interface. Owing to the ease of use and security features it brings to the table; MS Access has rapidly captured the market to become one of the most widely used database systems. However, errors can occur even in the most secure of user defences, and MS Access is no exception to this.

Microsoft Access Database Error 2950

MS Access is not error-free. The most vulnerable point of MS Access where most errors occur is Macros. While Macros introduce a level of automation within Access, scripts that make the execution of Macros possible can get corrupt easily thus leading to unexpected errors. One of the most commonly occurring Macro errors is, “Action Failed Error Number: 2950”. Let us discover the causes behind this error and a few easy solutions to fix it. The user will receive the following error message on the screen:

Action Failed
Macro Name: MacroName
Condition: Condition
Macro Name: RunCode
Arguments: Arguments
Error Number: 2950

This is the screenshot of the Access Macro Error 2950

Macro Failed error

Primary Reason Behind Access Database Error 2950

MS Access Error 2950 is received when a macro calling a VBA (Visual Basic for Applications) function is run. The primary reason behind the occurrence of this error is that the database from which the macro in run is not trusted by MS Access. By default, Access opens databases that are not trusted in the Disabled mode. In the Disabled mode, executable content is disabled.

Common Fixes to Resolve Microsoft Access error 2950

Listed below are the common fixes to the error. Apply any of the following

  1. Enable the Database for Current Session

This method will enable the database only for the current session. The database will be disabled as soon as you initiate a Close Database command. Follow the steps below:

  • In the Access message bar, click on Options
  • This will open MS Office Security Options dialog box. Click on Enable this content
  • Click OK
Enable Microsoft Macro Content

Note: These steps should be repeated each time you open the database

  1. Move the Database to a Trusted Location

For this, you must first find out the trusted locations on your system to which you can move the database. To do so, perform the following steps:

  • Click on MS Office button -> Access Options
  • Select Trust Center -> Trust Center Settings
  • Go to Trusted Locations and then do any of the following:
    • Note the paths of the trusted locations listed
    • 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
Trusted Locations

Once you have the trusted locations list, move the Access database to any one of them.

Recommended Solution

In case you’re unable to perform any of the above-mentioned fixes or the problem still persists, then there may be an issue with your database files. Here, Stellar Repair for Access may serve the purpose. This advanced software not only has the capability to fix the MS Access error number 2950 but other Access errors too as well as severe cases of the corrupt database. It can repair corrupt MDB and ACCDB database files to restore tables, queries, indexes, and relations. Moreover, the product supports Linked tables and calculated data type and can retrieve password-protected forms and modules.

free download

Final Thoughts

Every problem has a solution, especially if you have the right kind of help. Though MS Access database related issues are quite easy to resolve at the user’s end, however, at times, the solutions can be tricky or too technical. In such scenarios, leveraging the secure and reliable Access repair software, Stellar Repair for Access may be purposeful.

Comments(23)
  1. Dave March 1, 2020
  2. Lavis brown September 26, 2019
  3. Frank August 25, 2019
  4. Lloyd Thiessen August 23, 2019
  5. Mike Moore April 16, 2019
  6. Michael January 7, 2019
    • Eric Simson January 8, 2019
  7. Eric Simson November 28, 2018
  8. Christine Robin November 27, 2018
  9. Navdeep October 4, 2018
  10. Henry July 21, 2018
    • Eric Simson July 23, 2018
  11. Raymond July 11, 2018
    • Eric Simson July 12, 2018
  12. Fred June 27, 2018
    • Eric Simson June 29, 2018
  13. Jordan May 25, 2018
  14. Naomi Garner January 3, 2018
  15. Adam June 29, 2017
    • Jyoti Prakash June 30, 2017
  16. John Lopez June 9, 2017

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.