William Hindman
wdhindman at dejpolsystems.com
Mon Sep 11 19:57:32 CDT 2006
...it should but then what you've done already should have worked as well. ...you might give this a shot first ...its from an MSKB article that I can't find at the moment but from which I have notes in my Treepad: 1) decompile the mdb from A2K3, recompile, save, close. 2) open the mdb in A2K3 3) add a digital signature (use the wizard to create one first if you've not done it before) 4) save and close the mdb 5) open the mdb in A2K3 6) remove the digital signature 7) save and close the mdb 8) open the mdb in A2K3 (if you open it in another version first, the digital signature will still be there) 9) save and close the mdb ...you should now be able to create an A2K mde that will open in A2K without the warnings. William Hindman ----- Original Message ----- From: "Beach Access Software" <bchacc at san.rr.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Monday, September 11, 2006 5:43 PM Subject: Re: [AccessD] Security Level > If I created a new mdb in A2K and imported all the objects from the other > one, then made the mde from that, do you think that would work? > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly > Sent: Monday, September 11, 2006 12:42 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Security Level > > Well Access 2000 didn't have certificates for vba code. > I think only for Word 2000 and Excel 2000. > > If you created an mdb in 2003 with a certificate converted to 2000 format > and then you opened in Access 2000 and created an mde. You invalidated > the digital > signature by opening the file in Access 2000 and running the MDE > conversion > utility. To explain, you opened the MDB file in Access 2000, which > doesn't > support digital signatures, so slight changes were made to the file in > order > to successfully create the MDE file, making it "altered" from the > original. > If a signed file has been altered, then the digital signature becomes > invalid. That's what digital signatures are for. > > > A SelfCert digital certificate will work for medium level Macro > Security, but not for high. > > Does she have the signature in the digital signature cache > Go into IE --> Tools --> Internet Options --> Content > There is an import option. > > Also check for registry keys for 9.0 (2000) > either > > HKEY_Local_Machine\Software\Microsoft\Office\10.0\Access\Security\Level=1 > > HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level=1 > > Beach Access Software wrote: > >>Jim: >> >>That addresses Access 2003 and we're working in A2K ("At the High or >>Medium >>macro security level in Access," - that level's not available in A2K). >> >>So I'm looking for a workaround in A2K, and I'd prefer not to get into the >>digital signature problem at all if possible. >> >>Thanks and regards, >> >>Rocky >> >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman >>Sent: Monday, September 11, 2006 9:02 AM >>To: 'Access Developers discussion and problem solving' >>Subject: Re: [AccessD] Security Level >> >>Rocky, >> >>Here's the other way around that: >> >>http://office.microsoft.com/en-us/assistance/HP010446111033.aspx >> >>Jim. >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access >>Software >>Sent: Monday, September 11, 2006 10:31 AM >>To: 'Access Developers discussion and problem solving' >>Subject: [AccessD] Security Level >> >>Dear List: >> >> >> >>I wrote last week about my distributor in Taiwan not being able to run an >>mde - getting an error that the file does not have a digital signature. > The >>solution offered was, I think the correct one - Tools-->Macro-->Security, >>and select 'Low". >> >> >> >>However, she is running W2K with A2K and does not have that option. Is >>there a workaround for this in W2K/A2K? >> >> >> >>MTIA, >> >> >> >>Rocky >> >> >> >> >> >>Rocky Smolin >> >>Beach Access Software >> >>858-259-4334 >> >>www.e-z-mrp.com >> >> >> >> >> >> > > -- > Marty Connelly > Victoria, B.C. > Canada > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >