0

i am trying to create a button that will open a database from a vb6 system. I have got so far but i dont know what is meant to go instead of Database

Option Explicit
Dim ACC As Access.Application

Private Sub btnDatabase_Click()
Set ACC = New Access.Application
ACC.Database.Open ""
ACC.Visible = True

End Sub

would any1 be able to help?
thnx andy

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by andyhopper
0

hi. you can use shell command.try this

Shell ("C:\\Program Files\\Microsoft Office\\OFFICE10\\MSACCESS.EXE ""D:\db1\database\db1.mdb")
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.