error "security warning.."

[Tom]

I have an Access 2000 database shared across my network
and I got another PC to connected to the network with
Access 2003 installed on it. I got an error "security
warning: unsafe expressions are not blocked. To block
unsafe expressions, MS Jet 4.0 service pack or later must
be used..." when I try to open the database. I could open
and work on the database, regardless this error.
My questions are:
- do I need to install the Jet 4.0?
- if I install, would it limit certain functions of the
database?
- could Access 2003 corrupt the database?

Thank you in advance,

 

[Paul Overway]

You may want to install Jet 4.0 SP 8, which is available via Windows Update.
If you set macro security/sandbox the way Microsoft is suggesting, queries
in your application would be limited to certain functions. See
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q239/1/04.asp&NoWebContent=1 for a list of the
functions allowed. This is not an issue for most applications. However,
Microsoft has ommitted sandbox support for some functions that are not
harmful and have valid uses, i.e., Eval. So, you'll need to review your
queries and make sure that you're only using "approved" functions or set
macro security to low.

 

[Tom]

Thanks Paul,
I'll check my queries.

-----Original Message-----
You may want to install Jet 4.0 SP 8, which is available via Windows Update.
If you set macro security/sandbox the way Microsoft is suggesting, queries
in your application would be limited to certain functions. See
http://support.microsoft.com/default.aspx? scid=http://support.microsoft.com:
80/support/kb/articles/q239/1/04.asp&NoWebContent=1 for a list of the
functions allowed. This is not an issue for most applications. However,
Microsoft has ommitted sandbox support for some functions that are not
harmful and have valid uses, i.e., Eval. So, you'll need to review your
queries and make sure that you're only using "approved" functions or set
macro security to low.
--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com





.