Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open up Access in VB6

Status
Not open for further replies.

biggvito

Technical User
Oct 22, 2001
14
GB
Could anyone please tell me how to open up a Microsoft Access file in VB. I have used the Shell command but that opens access up fine but is it possible to open up a file of my choice aswell when access loads up.
 
Check out faq222-1527 "VB Access Programming Simplified" in FAQs. It might help you, or one of the other faqs.

O.
 
I did that 4 or 5 years ago. My best recollection is that you just pass the path and filename in the command line. Like so:
Shell "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICEMSACCESS.EXE C:\MYFOLDER\DBNAME.MDB"

Good luck,
Paul
 
Are you wanting to open any Access file in a VB program or a specific Access file?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top