Disable Security Open File

[ThaNguyen]

Hi all,

I have a macros run from Excel see below

Set AccessApp = GetObject("Y:\Orders.mdb", "Access.Application")
AccessApp.DoCmd.RunMacro "AutoUpdate"

Which is working fine before it would run the "AutoUpdate" and goes on to the next statement. Now it would prompt a Security Warning the you have to click on Open for it to continued.

How do I turn this warning off or have to code continue to go through without click on open.

I think there is some setting in the Reference that might have been missed.

Thank you in advance.

[lucas]

Set your security settings lower. No one here will help you do this programattically as it is considered hacking.

You could run any dangerous macro with that ability....

[ThaNguyen]

thanks:hi:

[Imdabaum]

thanks:hi:

If you are looking for more specific guidance and you are working in Access 2007, click on the "Security Options" button that appears. Then you have a couple options.

Go to trust center and you can add the network place to the trusted sites.

Or you can disable all macro warnings (not recommended by Microsoft) but if your network's security is taken care of, then you should be okay.


http://www.mac-net.com/1159484.page for more info.