how to import database from another file

[SweetDot]

Hi,
I have a list box that lists the tables inside another access database. I can obtain the path of that access database file, but how do I use the path so that the list box will display the tables?? Is it possible?

thanks

 

[luceze]

You could link to the MSysObjects table in the other database then set the datasource of the listbox to this sql string:

SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Type)=1));


HTH,
Eric