how to suppress the security warning in Access 2003

I have an Access 2003 database and it was designed to work as a "hub" to
open other Access databases. I use the VBA on the "on click" event to
suppress the Access 2003 macro security warning when it opens other Access
2003 databases. I am not allow to change the macro security to "low".
However the coding is working and it stops the macro security warning poping
up, but I need to apply the same code to the "hub" and I am not sure where
to apply it since there is no "AutoExec" macro in Access 2003. Users
normally open the 'hub" database by clicking the shortcut in the desktop.
Any suggestion. Thanks.

While Access 2003 doesn't give you the autoexec macro
functionality, it does give you the option of loading a
form at startup.

I've successfully tested on Access 2003\XP Pro having a
blank form with either code (preferable) or macros firing
from its on load event as the application start up form.
You might want to give this a whirl.

Hope this helps.

John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com
-----Original Message-----
I have an Access 2003 database and it was designed to
work as a "hub" to
open other Access databases. I use the VBA on the "on
click" event to
suppress the Access 2003 macro security warning when it
opens other Access
2003 databases. I am not allow to change the macro
security to "low".
However the coding is working and it stops the macro
security warning poping
up, but I need to apply the same code to the "hub" and I
am not sure where
to apply it since there is no "AutoExec" macro in Access
2003. Users
normally open the 'hub" database by clicking the
shortcut in the desktop.
Any suggestion. Thanks.


.