Pete
Yes I saw the piece of code as well but I not sure what to do with it.
The following is a mewbie question:
Do I need to create a seperate database and place in in the on load event on a blank form. Or can I embed it in the specific database that I want to load then set C:\<FileToOpen>.mdb to open its self.
It sounds like a stupid question but I've tried it both ways and on each occasion the multiple instance of the database started opening.
Jim
Main Topics
Browse All Topics





by: peter57rPosted on 2004-03-04 at 08:43:55ID: 10515476
Hello jnewman,
cation") ame <> "" Then
I'm not sure which MS article you are referring to, but to avoid the security message you have to set the security level outside of ACCess before opening the database.
You can create a VB script file with this code and start your app using this. (Code is from an MS article)
Const cDatabaseToOpen = "C:\<FileToOpen>.mdb"
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Appli
If AcApp.Version >= 10 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullN
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'."
End If
Pete
Pete