Summary: This blog discusses about Microsoft Access database error 2950. It explains the reasons behind the error and manual methods to fix it. You can also try using Stellar Repair for Access software to restore your database with all its data intact.
About Microsoft Access Database Error 2950
A macro is a useful tool in MS Access. It helps automate tasks that you often perform in a database. For instance, a macro may contain commands that you want to perform each time a button gets clicked. However, scripts that make the execution of macros possible can easily get corrupted and cause unexpected errors. “Action Failed Error Number: 2950” is one common error you may encounter when running a macro in an Access database. The complete error message reads as:
Macro Name: MacroName
Macro Name: RunCode
Error Number: 2950
Primary Reason Behind Access Database Error 2950
MS Access Error 2950 is received when a macro calling a Visual Basic for Applications (VBA) function is run in MS Access database 2007 or higher. The primary reason behind the occurrence of this error is that the database from which the macro is 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.
Methods to Troubleshoot Microsoft Access Database Error 2950
To fix the Access macro error 2950, try enabling the database by following any of these methods:
Note: Before trying these methods, you must first determine if you can trust the database.
Method 1 – Enable the Database for Current Session
This 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:
- Open your Access database. From the ‘Security Warning’ message bar, click on Options.
- When ‘MS Office Security Options’ dialog box opens, click on Enable this content and then click OK.
Note: These steps should be repeated each time you open the database.
Method 2 – Move the Database to a Trusted Location
Before moving the database, you must first find out the trusted locations on your system where you can move the database. To do so, perform the following steps:
- In MS Access, click the File tab and then select Options.
- From the ‘Access Options’ dialog box, select Trust Center > Trust Center Settings.
- Click Trusted Locations and then do any of the following:
- Note paths of the trusted locations listed under ‘User Locations’.
- 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.
Once you have the trusted locations list, move the Access database to any one of them.
What to do if the Error Persists?
In case you’re unable to perform any of the above-mentioned fixes or the problem still persists, there may be an issue with your database files. In such situations, use Stellar Repair for Access software to repair corrupt MDB and ACCDB database files, and restore macros, forms, queries, and other objects. The software also supports recovery of linked tables, calculated data types, and can retrieve password-protected forms and modules.
Every problem has a solution, especially if you have the right kind of help. You may find it easy to troubleshoot the error 2950 in Access database manually. However, at times, troubleshooting the error manually can be tricky and might fail to make the database accessible. But, leveraging a secure and reliable Access repair software, such as Stellar Repair for Access can help you restore the database without downtime.