MS Access Runtime Error 2001 in a macro

Question

Hi

I have an MS Access 2010 Database that runs fine in the full version of MS Access (on a Win7 PC) but when it is used on a machine using the runtime (on a Win8 machine) I get an error when running a macro to send an email.

The Macro runs fine creating tables and and adding data to the tables and so on, but as it needs to run the module "MacroSendEmailMinutes()" it comes with a RunCode error 2001.

Now additional Information:

When it opens I get the security warning and have tried to update the registry as suggested but I don't get the keys mentioned I am not sure if I need to create the key altogether.

I get a similar issue when running this macro on a machine with Win10.

I know this is old systems but I hope there are some with knowledge that will help me find a solution.

TX

Peter

Answer 1

"When it opens I get the security warning and have tried to update the registry as suggested but I don't get the keys mentioned I am not sure if I need to create the key altogether."

Which keys?  If you are referring to Trusted Location key, then yes, you have to create them.  You could also use Gunter's tool AddPath which can be found http://www.accessribbon.de/en/?Trust_Center:Trusted_Locations (look at the bottom of the page).

TX will test and revert

What is error 2001's description?  We'd need to see the code to be able to troubleshoot, assuming that the issue isn't entirely related to the Trusted Location issue.

In the run-time I get the Macro Single Step dialog box refers to the macro name that is being run, no condition

Action Name is RunCode

Error Number is 2001

the arguments refers to the module name "MacroSendEmailMinutes()"

in Access proper it runs fine there are a couple of send email modules and all do the same, ie work in Access proper but in the run-time give the same error.

Lastly, there is absolutely nothing wrong to be using 2010!

Thanx

Answer 2

"When it opens I get the security warning and have tried to update the registry as suggested but I don't get the keys mentioned I am not sure if I need to create the key altogether."

Which keys?  If you are referring to Trusted Location key, then yes, you have to create them.  You could also use Gunter's tool AddPath which can be found http://www.accessribbon.de/en/?Trust_Center:Trusted_Locations (look at the bottom of the page).

What is error 2001's description?  We'd need to see the code to be able to troubleshoot, assuming that the issue isn't entirely related to the Trusted Location issue.

Lastly, there is absolutely nothing wrong to be using 2010!