MartyConnelly
martyconnelly at shaw.ca
Fri Feb 11 12:19:45 CST 2005
Are you doing this just to get around macro security or do you really
want to sign them.
SageKey installs have a method of removing macro security.
There are a lot of if, but's and and's to this
Cause you will have to get around locked down users getting the
certificates into their own personal certificate store
Certificates expire, some in 12 months.
for Medium and High Access 2003 security, if you add the author to the
list of Trusted Publishers. It turns out thought that you cannot add a
self-signed certificate to the list of Trusted Publishers on any machine
other than the one where it was created. So this is hardly an option for
application deployment, after all.
Does CAcert produce a level 2 or 3 certificate. I think Verisign only
produces level 3?
If the mdb file will be used within an organization, use Windows
Certificate Services from server?
So you don't need a 3'd party certificate in above case
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsigningvbaproject.asp
http://office.microsoft.com/en-us/assistance/HA011225981033.aspx
http://office.microsoft.com/en-us/assistance/HP010397921033.aspx
What I have been doing is using a vbs script file in the opening
shortcut to the mdb
Const cDatabaseToOpen = "C:\<FileToOpen>.mdb"
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application")
If AcApp.Version >= 11 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullName <> "" Then
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'."
End If
Gustav Brock wrote:
>Hi all
>
>I'm not that much into certificates, but will those from CAcert:
>
> https://www.cacert.org/
> Code signing certificates
>
>do as Digital Certificates for Access 2003?
>
>/gustav
>
>
--
Marty Connelly
Victoria, B.C.
Canada