How ot Open file with assoc app

[Alabaster2100]

I need to open an access mdb but I dont know if they have access or the runtime. How would I launch the mdb as if I just put in its full path.

Thanks
Alabaster

 

[acron]

The ShellExecute API function would seem to be what you need.

Put the following at the top of a module :

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
    (ByVal hwnd As Long, _
     ByVal lpOperation As String, _
     ByVal lpFile As String, _
     ByVal lpParameters As String, _
     ByVal lpDirectory As String, _
     ByVal nShowCmd As Long) As Long
     
Then use the following to launch any document/file etc. If you pass it an Access filename it should launch Access, etc.
[code]
Private Sub LaunchApp(strFileName As String)
    ShellExecute 0, vbNullString, strFileName, vbNullString, "C:\", 1
End Sub

A.C.