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 >