Access2003 and Jet 4.0 sp 8.0

[jsr685]

I recently purchased in a local store Access 2003 to work with a new client. (already have Access97, 2000, and xp running on the system)
When I open a database I receive the warning that "unsafe expressions are not blocked. To block unsafe expressions, Micorsoft jet 4.0 sp 8.0 must be installed." Well, I downloaded sp 8.0 and installed it (I even verified that the correct files where there) and I continue to receive the above message.

Is there a way to NOT have the error message appear? I can't find code that would "damage" my computer. What don't I understand about this process? Would appreciate any help
thank
jsr

 

[Kristyn Wagoner [MSFT]]

Microsoft Access
2003 introduces this new warning for your protection. To turn this warning
off,
you can go to Tools, Macro, Security and set the security level to Low,
however,
this is not recommended, as it can leave your database vulnerable to running
potentially unsafe functions in queries such as Delete or Kill. If you are
given a
database that you did not create, it could contain such functions, so you
are
warned of this before opening the file. To help protect against macro
viruses, we
recommend that you run anti-virus software, set the macro security level to
medium
or high, and use digital signatures so that you know you are opening a
database
file that you can trust. For more information about macro security, please
view
the Help topic, "About helping protect files from macro viruses."


--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

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

I recently purchased in a local store Access 2003 to work with a new

client. (already have Access97, 2000, and xp running on the system)

When I open a database I receive the warning that "unsafe expressions are

not blocked. To block unsafe expressions, Micorsoft jet 4.0 sp 8.0 must be
installed." Well, I downloaded sp 8.0 and installed it (I even verified
that the correct files where there) and I continue to receive the above
message.

Is there a way to NOT have the error message appear? I can't find code

that would "damage" my computer. What don't I understand about this
process? Would appreciate any help.

 

[Mike Wachal]

I recently purchased in a local store Access 2003 to work with a new client. (already have Access97, 2000, and xp running on the system)
When I open a database I receive the warning that "unsafe expressions are not blocked. To block unsafe expressions, Micorsoft jet 4.0 sp 8.0 must be installed." Well, I downloaded sp 8.0 and installed it (I even verified that the correct files where there) and I continue to receive the above message.

Is there a way to NOT have the error message appear? I can't find code that would "damage" my computer. What don't I understand about this process? Would appreciate any help.
thanks
jsr

Hi,

The message you are seeing can be deceptive if you don't read the whole
message. Before you install SP8 you were getting a warning asking you if
you want to open the database even though unsafe expressions are not
blocked. Access 2003 can not use the Jet sandbox mode without SP8
installed.

Once you've installed Jet SP8, you get a very similar warning indicating
that unsafe expressions are not blocked and asking you if you would like to
block unsafe expressions. Installing SP8 does not automatically turn on Jet
Sandbox mode, you must do that yourself. If you answer yes to the question
"Would you like to block unsafe expresions?" when prompted, the warning
about expressions will stop.

Once you've done this, you will likely still see a warning when opening
your databases. This warning is the macro security warning that you may
have seen in other Office application such as Word or Excel. When macro
security is set to Medium or High, you are prompted every time you open a
database that has not been digitally signed by a trusted source.

Kristyn discussed changing your macro security options in a separate post
in this thread so I won't repeat the information, but I will echo her
suggestion that you read about macro security in the online help so that
you understand the purpose of the feature and what you lose when you turn
it off.


--
Regards,
Mike Wachal
Microsoft Corporation

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

 

[jsr]

I posted last week on macros security and access 2003. Well, I converted all of my macros to code to simplify the matter but I still get the warning message. Does this automatically appear even if there are NO macros in the database?

thanks.

jsr

----- Mike Wachal wrote: -----

I recently purchased in a local store Access 2003 to work with a new client. (already have Access97, 2000, and xp running on the system)
When I open a database I receive the warning that "unsafe expressions are not blocked. To block unsafe expressions, Micorsoft jet 4.0 sp 8.0 must be installed." Well, I downloaded sp 8.0 and installed it (I even verified that the correct files where there) and I continue to receive the above message.
thanks
jsr

Hi,

The message you are seeing can be deceptive if you don't read the whole
message. Before you install SP8 you were getting a warning asking you if
you want to open the database even though unsafe expressions are not
blocked. Access 2003 can not use the Jet sandbox mode without SP8
installed.

Once you've installed Jet SP8, you get a very similar warning indicating
that unsafe expressions are not blocked and asking you if you would like to
block unsafe expressions. Installing SP8 does not automatically turn on Jet
Sandbox mode, you must do that yourself. If you answer yes to the question
"Would you like to block unsafe expresions?" when prompted, the warning
about expressions will stop.

Once you've done this, you will likely still see a warning when opening
your databases. This warning is the macro security warning that you may
have seen in other Office application such as Word or Excel. When macro
security is set to Medium or High, you are prompted every time you open a
database that has not been digitally signed by a trusted source.

Kristyn discussed changing your macro security options in a separate post
in this thread so I won't repeat the information, but I will echo her
suggestion that you read about macro security in the online help so that
you understand the purpose of the feature and what you lose when you turn
it off.


--
Regards,
Mike Wachal
Microsoft Corporation

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

 

[Joan Wild]

Go to this link

http://office.microsoft.com/assista...ID=CH010411391033&CTT=4&Origin=CH790018001033
and check out the information under Macros.

The macro security warning is a misnomer in Access as it applies to macros,
VBA code, a form or report with an ActiveX control, or an action query.

So basically, any mdb.

More reading at the link above should help you understand the warning, and
help you decide how to deal with it.

--
Joan Wild
Microsoft Access MVP

I posted last week on macros security and access 2003. Well, I converted

all of my macros to code to simplify the matter but I still get the warning
message. Does this automatically appear even if there are NO macros in the
database?