Security Warning: Unsafe expressions

[Tom]

I have a db created in 2000. I upgraded to 2003 and,
when opening the db I get the message "Security Warning:
Unsafe expressions ar not blocked". It then goes on to
mention Jet 4.0 SP8.

Before I do anything more, can someone explain what's
happening? So I install the SP?

By the way, if I work my way through the screens telling
the system to ignore the risks, the db opens fine.

Tom

 

[Jeff Conrad]

Welcome to 2003 Tom! Here is some info on this subject:
(Watch out for any possible line wrapping on these links)

You can to go Tools, Macro, Security and set it to low.
If the security item isn't on that menu, you may need to reset your menubar. See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;833219&Product=acc2003

You can also manually add the following Registry keys:
Set registry as follows:

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

If these are just for your use, you can create a self cert on your computer
and digitally sign your databases. More info at:
http://www.microsoft.com/resources/documentation/office/2003/all/reskit/en-us/seca02.mspx

Other link to see:
http://office.microsoft.com/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings
http://office.microsoft.com/assista...ID=HA011225981033&CTT=4&Origin=CH010411391033