opening a database from vb6

Thread Solved
Reply

Join Date: Oct 2008
Posts: 8
Reputation: andyhopper is an unknown quantity at this point 
Solved Threads: 0
andyhopper andyhopper is offline Offline
Newbie Poster

opening a database from vb6

 
0
  #1
Oct 20th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Dec 2007
Posts: 45
Reputation: AUGXIS is an unknown quantity at this point 
Solved Threads: 11
AUGXIS's Avatar
AUGXIS AUGXIS is offline Offline
Light Poster

Re: opening a database from vb6

 
0
  #2
Oct 21st, 2008
hi. you can use shell command.try this
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Shell ("C:\\Program Files\\Microsoft Office\\OFFICE10\\MSACCESS.EXE ""D:\db1\database\db1.mdb")
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 8
Reputation: andyhopper is an unknown quantity at this point 
Solved Threads: 0
andyhopper andyhopper is offline Offline
Newbie Poster

Re: opening a database from vb6

 
0
  #3
Oct 21st, 2008
thnks very much, that worked just fine
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC