automation

[xcao]

I have a macro that runs a bunch of queries.
I'm using Access 2007, because of security, I found it's hard for me to automate the macro.

I don't use Access quite often, my question is if Access a good tool to automate process, I only know autoexc macro can be automated, but it needs to open access, and also now Access 2007 has more security like disable option for macros.
Or what other methods to use to automate Access?
Or I really need to consider sql server integration service.

Thanks

 

[HiTechCoach]

Have you set a trusted location for the folder where the database is located?

Have you tried setting the Macro security level to low?