[AccessD] database is not digitally signed

Well there is one way if you create a vbs file and open it from a
shortcut, this assumes the network nabobs allow vbscript to run
A bit more difficult if using a .msw file

Const cDatabaseToOpen = "C:\Access files\Access2003 samples\Using 
Parameters with Queries and Reports.mdb"
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application.11")
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

Jim Dettman wrote:

>  Note that there is no programmatic way to turn this off; the user must do
>it through the Access UI.
>
>Jim. 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia
>Sent: Wednesday, January 31, 2007 8:16 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] database is not digitally signed
>
>Nevermind I found the help on MSDN, I had to go to Tools > Security > Low
>:)
>
>
>On 1/31/07, Francisco Tapia <fhtapia at gmail.com> wrote:
>  
>
>>I used sagekey to install a demo copy of my own db for my end users,
>>version Access2003, I had been using the 2000 for years now w/o any
>>problems.
>>
>>Now the error that I am seeing is described here
>>http://office.microsoft.com/en-us/access/HA011225981033.aspx#080
>>
>>"Access cannot open the file due to security restrictions. Security
>>settings restrict access to the file because it is not digitally
>>signed"
>>
>>but what it does NOT tell you is how to set the macro security level
>>to low so that I CAN open the projects I was opening before I did the
>>wise install (sagekey) install.  I called Sagekey and the guy there
>>was stunned and asked me to re-install Access 2003... but that of
>>course has not fixed anything... :(
>>
>>
>>
>>
>>--
>>-Francisco
>>http://sqlthis.blogspot.com | Tsql and More...
>>
>>    
>>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada