Access 2003

[Michael]

Our company just upgraded to Access 2003 and now every
database that I created comes up with a security warning
when its opened. Does anyone know how to get around this
security warning in the database without changing the
actual security settings on the computer.

Thx.

 

[Mike Wachal [MSFT]]

Hi Michael,

If you have Jet 4.0 SP7 installed, you can manually turn on Jet Sandbox Mode
by changing the registry key value to 3. There is a KB article that
describes Sandbox mode at
http://support.microsoft.com/default.aspx?scid=kb;en-us;294698&Product=acc2003.
I'll warning you in advance, there is a known issue when using Jet SP7
sandbox mode in Access that cause some queries to return #ERROR instead of
the expected data. I've been successfully using SP7 with sandbox mode turned
on for several months now, no problems, but I don't have many expressions in
my queries. Just be aware of the issue and do some testing in your databases
to be sure there are no bad side effects. This issue is corrected by SP8.

The only other alternatives are to change your security level or to live
with the SP8 prompt for a bit longer.

Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.