open MS Access in VB from a user prompt on the menu

[rtvillan]

Hello,

How can a user open up and choose an MS Database from a user menu in a form ie -> File -> open .... then choose a DB. It has to be in ADO.

Example:

1. the File name is db1.mdf
2. when it's chosen, the fields are tied to the text boxes thru a connection string automatically.


Thanks.

 

[s2001]

HI

1. Use the common dialog to select the file.
2. Use the commondialog1.filename and pass that as
connection string while opening the Database.

**check my FAQ it will solve lot of your Questions. thread181-27567

If you need more help do let me know.

Thanks Murali Bala

 

[s2001]

I'm extremely sorry for pointing to wrong thread
check the below

Create Acess Database, Tables and Fields through VB
faq222-1422

Thanks Murali Bala