Security Question

[mercwonder007]

Everytime I open up my database I get a message that says: "Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions?" I then select "NO", Then it gives me another message regarding the Jet4.0 Service pack... I have gone to Microsofts page to download it and I still get the message. How do I turn this off?

 

[GingerR]

It will always ask that. Just hit YES, then re-start Access. This way it will set your sandboxmode registry setting to 3 and not ask you again.

Here's one article:

http://office.microsoft.com/en-us/assistance/HP010446591033.aspx

It notes:

Important Installing the latest version of Jet will not automatically enable sandbox mode. When you start Access after installing the service pack or the critical Windows updates, you will be prompted to block unsafe expressions. Clicking Yes will turn on sandbox mode and prevent unsafe expressions from getting evaluated.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html