[AccessD] Security Level

MartyConnelly martyconnelly at shaw.ca
Mon Sep 11 14:42:22 CDT 2006


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




More information about the AccessD mailing list