? Windows 7, Access2010, how can I pre-authorize or pre-enable MS access MDBs with macros ?
Posted on 2014-09-10
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.