Майкрософт аксесс ошибка 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 you want to execute each time a button clicks. 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:

Action Failed
Macro Name: MacroName
Condition: Condition
Macro Name: RunCode
Arguments: Arguments
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 this error is that MS Access does not trust the database from which the macro is run. By default, Access opens databases that are not trusted in the Disabled mode. In the Disabled mode, executable content is disabled, preventing you from running a macro.

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

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: Repeat these steps 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 to 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 anyone 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 pIn none of the above methods works for you, consider using an Access repair tool like Stellar Repair for Access to repair your database (MDB/ACCDB) files and restore macros. Download the free demo version to preview the recoverable macros and other objects before saving the repaired file.

Final Thoughts

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 and its objects without downtime.

If you are encountering the MS Access error 2950- “Action Failed” when attempting to run a macro in the database, don’t fret. In this post, I will discuss what does error 2950 mean in Access, why this error occurs, and how to get rid of it with less effort.

Here is how the error actually looks like:

Besides, I will also explain how to fix error 2950 Access with the help of advanced Access Repair Software if it has occurred due to database corruption.

So, read further to know in detail…

What Does Error 2950 Mean in Access?

When the Microsoft Access error 2950 occurs it simply means that you can’t run the macros calling a VBA in your database. Although it is the numeric data format of the error code that is developed by Windows as a standard error layout.

Also, this error message provides you practical brief description as well as a numeric number. In many situations, it might have additional parameters in the format of error number 2950 Access. The additional numerical code of the error message is the address of the memory sections that are loaded with the guidelines at the time of the error.

Why 2950- Action Failed Error Occurs in MS Access?

Well, this error triggers due to numerous reasons, like:

1. Incomplete MS Access installation
2. Due to database file corruption
3. Missing system files
4. When Access opens the database that is not trusted in a Disabled mode
5. The system is infected by adware/spyware.

As you have known the common factors now, let’s proceed to troubleshoot this problem with the best workarounds.

Follow the below step-by-step tricks to tackle this situation.

Solution 1- Enable Database for the Current Session

The very first solution that I would like to suggest is to enable database for the current session. This will disable the database as soon as you begin the command ‘Close Database’.

Here is how you can execute the steps:

• Open the Microsoft Access.
• Then, click on Info and tap on Security warning message bar.
• After this, click on Enable All Content option >> Advanced Options.
• Now, you will see the ‘Microsoft Office Security Options’ window.

• In that opened window, you have to choose Enable content for this session>> click OK.

Also Read: Fix ‘Cannot Open or Run Macro’ (Error 32002) in Access

Solution 2- Moving The Database To Any Other Trusted Location

If you want to move the Access database to fix MS Access error 2950, then you need to first determine trusted locations on your PC. In order to do so, follow these steps:

• In the MS Access software, open the MS Office button wizard.
• Click Access Options.
• Microsoft Office Access trust center > Trust Center Settings > Go to Trust Center

• Click the trusted locations field and then set the trusted location from the list.
• In order to add another trusted location click add new location.

Likewise, you can shift the database to trusted locations which can be helpful in diminishing the MS Access database errors.

Solution 3- Configure The AutoExec Macro

In such unexpected situations, you can also configure the expert AutoExec macro which warns you about the database’s untrusted state when you open any database. To configure AutoExec, perform the following steps and solve error 2950 Access:

• In the MS Access application, create a new form.
• Add the label and the text box object in the form.
• Save the newly-created form and close it.
• Create and then name a new macro as AutoExec.
• Display the conditions field columns.
• Specify the CurrentProjectIsTrusted= False in conditions.
• Go to the Actions column, and then click the OpenForm option.
• Action Arguments.>Go to Form Name

• Select the newly-created form.
• Save the macro.

By applying these entire solutions one can be aware of the root cause to avoid the occurrence of action failed error number 2950. But as most of the users are engaged in saving the database, the situation leads to the corruption of MDB OR ACCDB files which results in crucial data loss.

Also Read: Repair Damaged Access Macros And Modules

Solution 4- Use Compact & Repair Tool

As mentioned in the causes, the Access database corruption can also trigger this error code 2950 when you try to open the file. In such a situation, you can try Access in-built Compact and Repair tool to repair corrupt Access database (.mdb & .accdb) files.

Follow the below steps to run this utility:

• Open the MS Access.
• Then, click on File menu.
• After this, click on Info option then Compact & Repair Database.

If this free utility fails to solve the problem, you must go with the next automatic solution.

Solution 5- Go With The Professional Recommended Option

In order to restore the database’s inconsistent state, one might need the assistance of a trustworthy third-party tool. You can use MS Access Repair Tool to fix Access 2013 error 2950. It can easily repair and recover corrupt, damaged, and inaccessible data. With the help of this tool, you can easily recover the database from any sort of corruption.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

It can easily retrieve corrupt indexes, queries, relations, and tables. Password-protected modules or forms can also recover with the help of this tool. This software will work on almost all versions of Windows OS, like Windows 95/98/ME/NT/2000/2003/Vista/7/8/8.1.

Steps to Fix Microsoft Access Database Error 2950

Final verdict:

The aforementioned fixes are just perfect to resolve MS Access error 2950. So, carefully try the manual fixes, and if you are not sure about the correct application of it. Then it’s better to approach the automatic solution.

That’s all…

Load More

If you are looking for a way to resolve the MS Access error 2950, then you have landed on the right blog. This blog is going to tell the pre measures a user can take to solve this inconsistency issue in the MS Access file. 

MS Access is a well-known database framework that is also a part of the MS Office Suite. In spite of the fact that the productivity of MS Access isn’t in question, Access clients frequently encounter errors from time to time. Macros are considered as the most defenseless part of MS Access, as the vast majority of the errors come under the Macros. In fact, the contents that comprise Macros gets damaged, issuing the Error 2950.

Now, let’s take a look at how-to solutions, the reason behind, and an alternative solution to resolve the error.

Reasons behind Occurring Error 2950

• Trust Issues: Whenever a database is accessed by the user, the application verifies whether a database can be trusted or not. If the database is considered faulty, the Access goes to disable mode and displays the error 2950.
• Windows System Failure: Abrupt system failure can also cause the error 2950. If any file is lost from the database without wasting a second it displays the particular error. This error can also be caused by Incomplete hardware, improper installation, etc.

3 Methods to Repair MS Access Error 2950 Manually

Method 1: Validating the database for the ongoing session

Follow the below-mentioned steps for enabling the database for the present session.

•  Open MS Access on your local system.
•  Redirect to the Message tab and press the Options button.
• A window named ‘’Microsoft Office Security Options’’ will open. 
• Hit the ‘’Enable this content’’ radio button, then click OK.

Method 2: Shifting the database to a user-specified location

To repair MS Access Database error 2950, follow the instructions mentioned below.

• Open the MS Access application on your local PC.
• Now, hit the ‘’Microsoft Office’’ button, then choose the Access Option.
• Pick the ‘Trust Center’ option, then go to Microsoft Access Trust Center and hit the ‘Trust Center Settings’.
• Next, select a Trusted Location from the given list, in the left side pane. 
• A user can also add a new location as a trusted location by hitting Add a new location button.
• This is how one can shift from one location to another comfortably.

Method 3: Configure the AutoExec Macro

In this method, connecting to the AutoEx Macro will keep notifying you about opening the untrustworthy database. The steps to do so are as follows:

• Launch MS Access application on your PC.
• Generate a new form, add the label and add text to it.
• Next, save the form and hit Close a button.
• Design a new macro called ‘AutoExec’.
• Show constraints in column field and establish CurrentProjectIsTrusted = False condition.
• Now, redirect to the Actions menu and hit the Open Form option.
• In the Actions tab, hit the Form Name.
• Choose the newly created form and then save the Macro.

If the user is not satisfied with the above three methods, then he/she can also try out the fourth method- ‘’a third party solution’’. This method is specifically built for recovering MS Access inconsistency issues. One such solution is Access Database Recovery. The utility claims to repair ACCDB/MDB files exclusively, facilitates methods to resolve the misalignment issues, compatible with all Windows OS versions, allows previewing the access database files before downloading, etc.

Now, let’s take a look at how the utility helps to repair error 2950.

Working of the Utility

• Download and install the MS Access Repair software on your local PC. Next, choose a recovery mode. One can also tick the checkboxes to filter the records accordingly.
• After scanning process completion, hit OK on the Scanning confirmation message.
• Next, choose the database items one by one from the left pane. After recovery process completion, hit the Save button to store the resultant files.
• Choose an appropriate location to store the resultant files and then hit OK.
• Wait for the saving process to complete.
• After saving process completion, press the Ok button on the confirmation message.

Conclusion

From the above blog we conclude, the top 3 ways to fix MS Access Error 2950 along with an alternative method that can provide obsolete solutions as well, if the manual procedure doesn’t work properly. Abiding the ways of the method, one must always remember to make a correct decision before applying a method because a single mistake can put your data at risk. I hope you find this blog rewarding.

Related Post