Hi, Ralph.
When I tried to open an Access 2000 database I received a message
about unsafe content and needing to upgrade to Jet 4 SP8.
In order to escape this confusing maze, you need to pay close attention to
the messages. The message doesn't tell you that you need to upgrade to Jet
4.0 SP-8. The message states the following:
"For the Medium and High security levels to function properly, your computer
must also be configured to block unsafe instructions. Blocking unsafe
instructions affects all users on this computer. Do you want to block unsafe
instructions?"
Between this message and the bottom of the window where you can point your
mouse cursor on the "Yes," "No" or "Help" buttons, the confusing roadblock
appears. The "Help" topic, which was written for Access 2002, is placed in
the text box below the message to help explain unsafe instructions and
sandbox mode. Access 2003 comes with Jet 4.0 SP-8, so you already have the
requisite file. Computers with Access 2002 did not have Jet 4.0 SP-8
installed originally, so the message about Jet 4.0 SP-8 being required for
blocking unsafe instructions applies to that version, not Access 2003.
Some advice about what to do about this please?
To avoid these messages, set the macro security level to "Low" before
opening databases you've built yourself. Change the macro security level to
"Medium" or "High" before opening databases that come from other sources.
Install a digital certificate for known sources so that you'll avoid the
security messages when opening their databases at these levels.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
