[AccessD] database is not digitally signed

SWEET! thank you :)

On 2/1/07, MartyConnelly <martyconnelly at shaw.ca> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...