2003 Security Warning won't turn off

[Dkline]

I just upgraded to 2003. I have tried to set the macro security to low as I
have a batch file that runs in the morning. The batch opens an MDB with an
AutoExec and updates an MDB for general use.

I keep getting the "Security Warning" in 2003 and this prevents the batch
file from completing until I intervene and hit the "Open" button. I have
tried to folow the prescribed metod of Tools\Macro\Security to set it to low
to prevent this problem. BUT I go to Tools, select Macro , but I can't
select Security because it isn't there. It is for all the other
applications - just not in Access.

Any help would be appreciated.

 

[Dkline]

The software was installed by the Administrator. At the Administrator level
the software does show on the menu \Tools\Macro\Security and it is set to
Low.

However when I sign-on as user and open the database, I still get the
message about unsafe expressions. The Tools\Macro portion of thge menu
apppears but Security doesn't show - not at all, not even grayed out.
According to Microsoft:
How to disable sandbox mode
Follow these steps to disable sandbox mode:


1.. On the Tools menu, point to Macro, and then click Security.
2.. Click the Security Level tab, and then click Low.
3.. Click OK.
4.. Restart Access.
Note At this security level, macros are always enabled when you open files.

Note Disabling the sandbox mode setting applies to all users of the
computer.

So since the Administrator set the level to Low and it is supposed to apply
to all users, why am I still getting this message?

 

[Joan Wild]

The software was installed by the Administrator. At the Administrator
level the software does show on the menu \Tools\Macro\Security and it
is set to Low.

So since the Administrator set the level to Low and it is supposed to
apply to all users, why am I still getting this message?

Because it doesn't apply to all users, just the Administrator. Log in as
the user, open Access, and reset the menu bar in Toolbars, Customize. Then
you'll see the security item in the tools, macro menu.

 

[Dkline]

A thousand "thank you". Didn't know you could do that. You are a life saver.

 

[Joan Wild]

A thousand "thank you". Didn't know you could do that. You are a life
saver.

You're welcome!

 

[Guest]

Question though.. if u have say 50 people using the application would u have
to go to everybody's machine and change teh settings individually?