In this article, we learn about ways to deal with error 2950 in MS Access.
Although MS Access has been designed intelligently by its makers, there are still occasions when you might come across the most unexpected and sudden errors. No matter how many security and safety features we get, full proofing the application against any kind of error has still not been made possible. And one of the most commonly occurring errors in Access application is the error 2950 in Macros. The “Action Failed” Macro error occurs mainly because Access does not trust the source of this macro. This error occurs usually when macro calling VBA function is run.
If Access does not trust the database housing the macro, it will open the database in the Disabled Mode by default. And once the database is in disable mode, the user would anyways fail to get access to executable content. But this is not an error that cannot be dealt with. Once we know what is causing the error, we can easily look for a solution. So given below are a few quick fixes for dealing with error 2950 in MS Access, while ensuring the safety of your data.
Enable Database only for the Current Session
This method involves enabling the database for the current session only, and then disabling it when closing the database. If you opt for using this method to deal with the error, then you will have to opt for doing this every time you open or close the database. The steps for the same are given below.
- Go to Access message bar and select Options
- The MS Office Security Options dialog box will appear in front of you, in this dialog box, select ‘Enable this Content’ option.
- Click on OK
Store Databases in Trusted Location
If you believe your database is currently in an unsafe location, the first thing you need to do is move it to a safe location. For this, you will first have to figure out what are the safe locations in your system where you can store the database. Once you have found these locations, move your database over there, by following these steps.
- Select MS Office, go to Access options, click on Trust Center and select Trust Center Settings.
- Now go to Trusted Locations, form here note the paths of all the trusted locations that have been listed over there.
- If you wish to add a new trusted location over here, you can do it by selecting ‘Add new location’ and specifying the path that leads to the location which you wish to add.
If you are not able to perform the solutions listed above or are continuing to face the problem even after you have tried these, you might want to have a look at your database files. The issue probably lies over there. Here you might want to opt for taking help of any third party mdb fix tool that might help you solve the problem.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including SQL Server recovery and excel recovery software products. For more information visit www.datanumen.com