? Windows 7, Access2010, how can I pre-authorize or pre-enable MS access MDBs with macros ?

We have a Windows 7 environment with Server 2008 active directory.

I have an MS access application with front ends (FEs) and back ends (BEs).
We replace one of the backend  MDBs each month to acquire new data for the Front End.

I've recently changed the front-end to use an AUTOEXEC macro that fires some VBA code to Dynamically re-link the BE.
that way, we can use Back End MDB names like CASEnumbers_2014_08  and the front end will dynamically determine the most recent Back end MDB and start using it.

The problem I face is that the AUTOEXEC stops and goes to single-step mode and MS ACCESS 2010 puts up a warning message requesting that the user "enable" the macro content.

Is there a way using GPOs or other means to pre-enable the macro.
I'd also like to get rid of a nuisance "run" window that pops up when the MS access is fired up.

thanks
Phil
LVL 1
philkryderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can add Trusted Locations in several ways. Modifying the registry is usually the best way, but note that must be done with a user account with sufficient permissions, and it must be done BEFORE the application runs - in other words, you could not include code to do this in a database that is NOT in a Trusted Location (since the code you added would not run, obviously).

See this article for several ways to achieve this: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_10805-Overcome-the-Trust-Center-Nuisance.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aikimarkCommented:
Those settings are saved in the registry.  You would need to tweak the registry by some means.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
So what was the reason for the B grade? The answer is correct, and you asked for no followup advice ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.