Warning Messages in Access2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database which I developed in the 2002 version and contains
VBA code. When opened in Access 2003 there are a number of warning dialogue
boxes saying the application may contain unsafe code. How to you get rid of
these?Unfortunately I do not have the 2003 version, so I can't explore ways
of doing this myself.
 
You can change the security level of Access, digitally sign your VBA code,
and use a Visual Basic Script to open you application.

http://office.microsoft.com/en-us/assistance/HA011071651033.aspx
http://www.vbforums.com/showthread.php?t=285212

(Paste code into notepad and save as a .vbs file extension.â€
Const cDatabaseToOpen = "<Path and DB File Name>"
On error resume next

Dim AcApp
Set AcApp = CreateObject("Access.Application")

If AcApp.version >= 11 then
AcApp.AutomaticationSecurity = 1
End if

AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen

If Acc.CurrentProject.FullName <> " " Then
AcApp.UserControl = True
Else
AcApp.Quit
Msgbox " Failed to open ' " & cDatabaseToOpen & " '. "
End if
 
Back
Top