Hi,

In a VB program, I'm opening a database file (.mdb) in a textbox using data control. I select the file name from a listbox and it opens fine.

But when I select another file name from the listbox, the data control does not switch to this new .mdb file and does not display the new data (even though I assign the new database file name to the 'databasename' property of data control)

How do I completely close connection from the previous mdb file and open a new mdb file. Thanks for helping in advance.

Syed