Vba ошибка 2501

Background:

I’ve been working on a macro to post company reports to out SharePoint site. The code runs in an instance of Access 2016. It works if I change the filelocation to one of my local drive, but not the Sharepoint site. I’ve spent days researching the error, but none of the results apply, and none of the fixes work.

Code:

Function CopySJIToWeb()


Dim fileLocation As String, fileName As String
Dim counter As Integer, i As Integer, store As Integer
Dim nstores(4) As Integer

nstores(0) = 31
nstores(1) = 37
nstores(2) = 41
nstores(3) = 44
nstores(4) = 57

FileName = "12 Dec 2015 Sales Journal.pdf"
counter = 1
store = 1

Do While counter < 59
     FileLocation = "http://192.168.100.12/holiday store " & store & "/holiday " & store & " sales journals/"
     DoCmd.OutputTo acOutputReport, "Sales Journal", acFormatPDF, FileLocation & FileName, True, "", 0, acExportQualityPrint
     SendKeys counter
     SendKeys "{ENTER}"
     counter = counter + 1
          If counter > 2 Then
               store = store + 1
          End If
          If store > 30 Then
               For i = 0 To 4
                    If store = nstores(i) Then
                    store = store + 1
                    End If
               Next i
           End If    
Loop

End Function

Running this throws the error: «Runtime error 2501. The OutputTo action will be cancelled.»

My office account has the necessary permissions and in my browser I’m logged in as said account, so I can’t see permissions being the issue. The network location is correct, and I’ve tried using both the ip address and site’s name in the file location. I’ve made sure there are no non existent spaces or other characters. I’ve also tried using %20 instead of spaces in the filename, in case those spaces were being stripped. Microsoft’s documentation of the 2501 runtime error has been incredibly unhelpful.

So what causes this error? What specifically is happening underneath it all? And what are other ways to resolve it?

	Error Number:	Error 2501
Error Name:	The | action was canceled
Error Description:	The | action was canceled.@You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box.For example, you used the Close method to close a changed form, then clicked Cancel in the dialog box that ask
Developer:	Microsoft Corporation
Software:	Microsoft Access
Applies to:	Windows XP, Vista, 7, 8, 10, 11

The | action was canceled Assessment

Experts generally refer to The | action was canceled as a «runtime error». Developers like Microsoft Corporation usually go through several checkpoints before launching a software program like Microsoft Access. Tragically, problems like error 2501 can be missed, and the software will contain these problems on release.

Error 2501 might be faced by Microsoft Access users if they are using the program regularly, also seen as «The | action was canceled.@You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box.For example, you used the Close method to close a changed form, then clicked Cancel in the dialog box that ask». In the event of the detected error 2501, customers may convey the presence of problem to Microsoft Corporation via email or bug reporting. They will then patch the defective areas of code and make an update available for download. This situation happens due to Microsoft Access software upgrades being one of the solutions for error 2501 errors and other problems.

Why Does Runtime Error 2501 Happen?

A problem with Microsoft Access source code will produce this The | action was canceled, most often during the startup phase. Let’s analyze some of the most common causes of error 2501 runtime errors:

Error 2501 Crash — This is a typical runtime error 2501 error that crashes the machine entirely. This emerges when Microsoft Access fails to respond to input properly, or does not know what output is required in return.

The | action was canceled Memory Leak — When a Microsoft Access Memory leak occurs, this can result in the device running slow due to system resources running short. It may be triggered by the misconfiguration of the software by Microsoft Corporation, or when one command starts a loop which can’t be ended.

Error 2501 Logic Error — Logic error happens when the PC produces the wrong output, even when the user enters the right input. This can happen when Microsoft Corporation’s source code has a vulnerability regarding data handing.

The root causes of Microsoft Corporation errors associated with The | action was canceled include a missing or corrupt file, or in some cases, a past or present Microsoft Access-related malware infection. A large percentage of these file issues can be resolved with downloading and installing the latest version of your Microsoft Corporation file. We also recommend running a registry scan to clean up any invalid The | action was canceled references which could be cause of the error.

Typical The | action was canceled Errors

Typical The | action was canceled Errors That Occur in Microsoft Access for Windows:

• «The | action was canceled Error.»
• «The | action was canceled not a Win32 program.»
• «Sorry for the inconvenience — The | action was canceled has a problem.»
• «The | action was canceled can’t be located.»
• «The | action was canceled can’t be found.»
• «Error starting program: The | action was canceled.»
• «Can’t run The | action was canceled.»
• «The | action was canceled failure.»
• «Faulty Program Path: The | action was canceled.»

The | action was canceled EXE errors happen during Microsoft Access installation, while running The | action was canceled-related applications (Microsoft Access), during startup or shutdown, or during installation of Windows OS. It’s important to note when The | action was canceled issues happen, as it helps troubleshoot Microsoft Access problems (and report to Microsoft Corporation).

Origins of The | action was canceled Troubles

The | action was canceled problems can be attributed to corrupt or missing files, invalid registry entries associated with The | action was canceled, or a virus / malware infection.

In particular, The | action was canceled problems originate through:

• The | action was canceled registry keys invalid / corrupted.
• Virus-contaminated and corrupted The | action was canceled.
• The | action was canceled mistakenly deleted or maliciously by software unrelated to the Microsoft Access application.
• A different application in conflict with The | action was canceled, or other shared references.
• Microsoft Access / The | action was canceled corrupt from incomplete download or install.

Product by Solvusoft

Download Now
WinThruster 2023 — Scan your PC for computer errors.

Compatible with Windows 11, 10, 8, 7, Vista, XP and 2000

Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall

The error 2501 can occur on calling On Close event of report, if there is a problem with the database. While working with reports and Forms error 2501 can be occur, if database go corrupted or changed. There are many reasons for this error like as row deletion in database or changed, data source key field is no longer primary key and relationships are gone, Network Connect Lost of data source etc.

In this article firstly we are reproducing this error, and then resolving this. To reproduce this error we need create report that has data source table. When we open the report in report view, it will show all the data of table. Suppose suddenly there is change in data of table and simultaneously we close report, then an error message will pop up, Run time error 2501; the close action was cancelled as shown in Fig 1.1.

For that we have also write code for close report on, Close event of report. We can avoid this error by using error handling technique, performing step by step action on database and maintain backups. In our case we have to save the report on close event.

VBA code on close event of report:

Option Compare Database
Private Sub Report_Close()
DoCmd.Close
End Sub