jeffrey.demulling at usbank.com
jeffrey.demulling at usbank.com
Wed Feb 16 14:15:06 CST 2005
You are playing in a "sandbox" (Microsoft's term, not mine). From the
On-Line Help
Enable or disable sandbox mode
Show All
Hide All
When Access runs in sandbox mode, expressions that use unsafe functions and
properties are blocked. Unsafe functions and properties are those that
could be exploited by malicious users to access drives, files, or other
resources for which they do not have authorization. Expressions that use
these functions and properties will result in an error.
For more information on sandbox mode, see the Access Help topic About
Microsoft Jet Expression Service sandbox mode. For more information on how
to troubleshoot sandbox mode, and work around its limitations, see
Frequently asked questions about Access security warnings.
Enable sandbox mode
If you have not installed Microsoft Jet 4.0 Service Pack 8 (SP8) or later
Install Microsoft Jet 4.0 Service Pack 8 (SP8) or later.
For more information on downloading Jet 4.0 SP8 or later, see About
Microsoft Jet 4.0 SP8 or later. A critical Windows update includes Jet 4.0
SP 8, so installing all the critical Windows updates will automatically
install the latest version of Jet on your computer. If your computer is
up-to-date on critical Windows updates, you can skip this step. To install
critical Windows updates or to verify that all critical updates are
installed on your computer, visit Microsoft Windows Update.
If you try to enable sandbox mode without installing Jet 4.0 SP8 or later,
several Access features will not work properly. For example, trying to run
the Form Wizard will display the following message:
Wizards may not start.
Switchboards created by using the Switchboard Manager won't function
properly.
You can't use the RunCode macro action to call a Visual Basic for
Applications (VBA) procedure.
Event handlers that call VBA procedures won't function.
VBA procedures that are called from a property sheet or used in an SQL
statement won't function.
The following VBA functions won't work when called from a property sheet or
used in an SQL statement:
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
InStrB
InStrRev
MonthName
Replace
StrReverse
WeekDayName
Quit, and then restart Access.
Open a file.
The warning will be replaced with a prompt that asks whether you would like
to block unsafe expressions.
Click Yes.
When prompted to restart Access, click OK, and then quit and restart
Access.
The registry will be updated, and Access will run in sandbox mode. You will
not see the warning as long as Jet 4.0 SP8 or later is installed on your
computer and sandbox mode is enabled.
If you had disabled sandbox mode, and want to enable it now
Under the Tools menu, point to Macro, and click Security. If you do not see
the Macro menu item under the Tools menu, or the Security menu item under
the Macro menu, click the arrows at the bottom of a drop-down menu to
display the hidden menu items.
Tip If you want to see all menu items by default, on the Tools menu,
click Customize, click the Options tab, and select the Always show full
menus check box.
I still can't see the Security command under the Macro menu
On the Tools menu, click Customize, and then click the Commands tab.
Click Rearrange Commands, select Menu Bar, and in the Menu Bar box, click
Tools | Macro.
In the Controls section, click Add.
The Add command dialog box will appear.
In the Categories box, click Tools, and then in the Commands box, click
Security.
The Security command will appear in the Controls box.
Use the Move Up and Move Down buttons to position the Security command
where you want.
If you'd like to position the Security command in its own group (between
horizontal lines), with Security selected, click Modify Selection and click
Begin a Group. Select the menu item below the Security command, and repeat.
Click Close twice.
Select Medium or High, and click OK.
You will see the security warning message box.
Click Yes to enable sandbox mode, and then click OK. Access will close.
Restart Access.
Note By default, security level is set to Medium, and sandbox mode is not
enabled. So, if you have not changed the default settings, simply
displaying and closing the Security dialog box, irrespective of whether you
make any changes in the dialog box or not, will display the security
warning message.
Disable sandbox mode
You have the option of disabling sandbox mode when the macro security level
is set to Low. However, setting the security level to Low is not
recommended.
Jeffrey F. Demulling
Project Manager
U.S. Bank Corporate Trust Services
60 Livingston Avenue
EP-MN-WS3C
St. Paul, MN 55107-2292
Ph: 651-495-3925
Fax: 651-495-8103
email: jeffrey.demulling at usbank.com
"Rocky Smolin -
Beach Access
Software" To
<bchacc at san.rr.co AccessD at databaseadvisors.com
m> cc
Sent by:
accessd-bounces at d Subject
atabaseadvisors.c [AccessD] Opening Access 2003
om
02/16/2005 02:03
PM
Please respond to
"Access
Developers
discussion and
problem solving"
<accessd at database
advisors.com>
Dear List:
Just got my Action Pack and installed Access 2003. Every db I open I have
to answer three questions:
1) Do I want to block unsafe expressions?
2) Do I want to open this file (because it may have unsafe expressions)
3) A third security warning. Do I want to open the file (YESSS!!! dammit)
Is there some want to disable these security checks?
TIA
Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.
==============================================================================