MartyConnelly
martyconnelly at shaw.ca
Thu Feb 17 11:51:38 CST 2005
This might help for a site running Windows server that has a Microsoft Certificate Server. Should work for mdb's too, I think , haven't got Win2003 Server to test Note the certificates that are produced by MS Certificate Server are probably not transferrable outside it's own domain then you are going to have to use one of these root certificate 3'd party http://msdn.microsoft.com/library/?url=/library/en-us/dnsecure/html/rootcertprog.asp How to add a digital signature to an Access 2003 run-time application http://support.microsoft.com/default.aspx?scid=kb;EN-US;832510 Rocky Smolin - Beach Access Software wrote: > (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 >> > -- Marty Connelly Victoria, B.C. Canada