The error 2950 occurs in the Access database when you try to run macro. This error can prevent you from accessing the macros or other objects in the database.
It usually occurs when MS Access doesn’t trust the database and open it in disabled mode. In this mode, MS Access disables the executable content (macro) in the database.
However, there could be many other reasons for this error, such as system files are missing or corrupted, issue with the macro settings, corruption in the database, etc.
In this article, we have shared some tried and tested methods to fix the Action Failed Error Number 2950 in MS Access.
Methods to Fix the MS Access Database Error 2950
You can follow the below methods to fix this MS Access error.
Method 1: Enable the Database for the Current Session
You can get the 2950 error when the database is not trusted by Microsoft Access. You can try enabling the database using the below steps:
- Open your MS Access database.
- On the Security warning message bar, select Options.
- In the ‘Microsoft Office Security Options’ wizard, select “Enable content for this section” and click OK.
This will enable your database until you give a close database command.
Method 2: Enable the DDE Refresh Option in Access
Dynamic Data Exchange (DDE) in Access plays a vital role for establishing a link between database files.
In macro-enabled database files if this option is disabled, then Microsoft Access may fail to execute the macros, resulting in the error.
You can try enabling the DDE and Local File Links to fix the issue. Here are the steps:
- Open the Access database.
- Go to File > Options.
- In the Access Options window, click Client Settings, select Enable DDE refresh, and click OK.
Method 3: Check the Macro Settings
The Access error 2950 can occur if you’ve set some security restrictions on the database which are preventing the execution of macros.
In this case, you can check whether the macros are enabled or not. Follow the below steps:
- In Access, go to File > Options.
- Click Trust Center and then click Trust Center Settings.
- In the Trust Center wizard, click Macro Settings and select Enable all macros.
- Once you have selected the option, click OK.
Note: Enabling this option could compromise the security as it allows to run all the codes, even the malicious ones, in the database. So, make sure the database is trusted.
Method 4: Move the Database to a Trusted Location
Many users have confirmed that they’re able to fix the issue by changing the database location. You can do this by following these steps:
- Open MS Access and click File > Options.
- Click Trust Center and click Trust Center Settings.
- Next, navigate to the Trusted Locations and click on it.
- Note the path of the trusted locations you see in the Trusted Locations, click Add new location option, and then enter the desired location.
- Now, move the database to that trusted location.
Method 5: Repair the Access Database
Corruption in the database is also one of the reasons for the MS Access 2950 error. You can try the Microsoft Access built-in ‘Compact and Repair’ tool to repair the database. Here’s how:
- Open MS Access.
- Click Info > Compact & Repair Database.
If the Compact and Repair utility fails to fix the error, then use one of the advanced Access database repair tool, such as Stellar Repair for Access.
This tool can repair corrupted MDB/ACCDB files and recover all the components, such as forms, macros, reports, forms, etc.
The tool can be installed on Windows 11, Windows 10, Windows 8.1, Windows 8, or Windows 7 system. It has a user-friendly UI. You can download the software’s free trial version to preview the repairable objects.
Conclusion
This article outlined the reasons behind the Access error 2950. You can try the methods discussed above to troubleshoot this error. If the error occurred due to corruption in the database, then you can use the Compact and Repair tool in MS Access. Alternatively, you can use which can easily repair the database and recover all the components with complete integrity.
Leave a Reply