[AccessD] Opening Access 2003

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Wed Feb 16 14:39:15 CST 2005


(deep sigh)

Rocky

----- Original Message ----- 
From: <jeffrey.demulling at usbank.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, February 16, 2005 12:15 PM
Subject: Re: [AccessD] Opening Access 2003


> 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.
> ==============================================================================
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list