Zeroanarchy
Technical User
I have not got a lot of experience with VB and I am looking for a way to open an access database.
I have tried
Dim RetVal
RetVal = Shell("c:\program files\access.exe, mydatabase.mdb", 1)
the problem with shell is if they have placed access somewhere else it will not work.
so I tried
Private Sub sampleLabel_Click(Index As Integer)
Dim db As Database
Set db = DBEngine.OpenDatabase("C:\mydatabase.mdb"
End Sub
and I get an error
compile error
User-defined type not defined
All I want it to do is run the database.
Thanks Zero
I have tried
Dim RetVal
RetVal = Shell("c:\program files\access.exe, mydatabase.mdb", 1)
the problem with shell is if they have placed access somewhere else it will not work.
so I tried
Private Sub sampleLabel_Click(Index As Integer)
Dim db As Database
Set db = DBEngine.OpenDatabase("C:\mydatabase.mdb"
End Sub
and I get an error
compile error
User-defined type not defined
All I want it to do is run the database.
Thanks Zero