Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HELP! - Access 2003 Developer Extensions

Status
Not open for further replies.

Vcscwi

Programmer
Jan 15, 2004
57
US
I've been running into one problem after another...here is the latest.

When I create the setup.exe with the Package Wizard and install it on a Windows XP PC without Office, but with MS Jet Database Engine 4.0 SP 8, it installs fine. When I double click on the icon I get an error...

“This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?”

Any tips to get rid of this?


 
Search on Google for "jet 4.0 sp 8" and you will see loads of ideas. Mostly you need to reduce the Access security level. As your package installs and runs Access Runtime which has no FE, I guess you may have to do this before you package the database.

Another way is to run the database from a VBscript that sets the security level to low as soon as Access starts.

Const cDatabaseToOpen = "mydatabase.mdb"

On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application")
If AcApp.Version >= 10 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullName <> &quot;&quot; Then
MsgBox &quot;Opened &quot; & AcApp.CurrentProject.FullName
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox &quot;Failed to open '&quot; & cDatabaseToOpen & &quot;'.&quot;
End If

I don't know if this works with runtime Access

Good luck,

Ian.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top