I am getting a 2950 error. I looked it up on MS support but the solution did not work. So let me explain. I have an Access program that is a Macro calling a VBA program via scheduler on a server. The program is run with AC2007 runtime.
It loads data to a back end database. The program is getting this message.
Action failed
Macro Name: ImportCounts
Condition: True
Action Name: RunCode
Arguments: LoadCounts()
Error Number: 2950
I have checked the Trusted locations and added the program location in the program. I was told this is a local setting and can not be set on the server because we are using AC2007 runtime. Anyway changing the settings did not effect the message. Is that true? How do I get the program to run?

I was told this is a local setting and can not be set on the server because we are using AC2007 runtime. Anyway changing the settings did not effect the message. Is that true? How do I get the program to run? [/FONT][/COLOR]
The trusted location HAS to be set in the registry on the server.

See here (http://accessjunkie.com/faq_33.aspx) for how to set the registry settings.