"Tools -> Macro -> Security" missing from menu

  • Thread starter Thread starter Joseph Sichelstiel
  • Start date Start date
J

Joseph Sichelstiel

Sorry for the cross post, but this may be a more
appropriate place for this thread.

I'm trying to run several access databases/macros as
scheduled tasks. I can not do this, however, because any
time I open an .mdb file, a 'macro security' warning pops
up & tells me that some macros may be unsafe etc etc
(this stops my scheduled task, since I can not go
farther).

The message says that the way to get rid of the warning
is to set my macro security to low (which is fine, since
I only work with access files I have created myself).
However, the menu that I am to change 'macro security' is
not available to me.

Everyone else in my company that uses Access 2003 can
find 'macro security' under Tools -> Macro -> Security,
but I can not. 'Security' is simply unavailable to me,
it does not appear on my menu (I have disabled the
arrow/drop down thing).

My IT dept. has tried uninstalling Office 2k3 and
reinstalling, but macro security is STILL unavailable for
me. The only choice is to wipe the computer clean and
start over, which I want to avoid at all costs b/c I have
ODBC connections that would need to be restored (it took
over a week to get them working properly last time I had
my system rebuilt).

Can anyone help me lower my access macro security level?
Why can't I get into that menu?

Thanks,
Joe
 
Dig around in the menus while in customize....it is there somewhere.

Alternatively, you can set it through the registry at:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security

Set it to 1 for low
 
Thanks for all the help, Paul. I still can't find
anything related to macro security, even in the customize
section.

Also, there is no registry setting for Access->Security
anywhere in the registry. I even tried making a new
security key, but I'm probably not doing it correctly.
 
Sorry...forgot the key..create a new Dword key under the entry mentioned
previously and name it Level. Set the value to 1
 
Thanks for the great idea. I actually had the notion to
check someone else's registry to get it to work. So far
so good.

Thanks for the great help!
 
Back
Top