Calling File|Open Dialog

[Kelly]

Is there a way to programatically call the Windows
File|Open dialog box and have the value selected, i.e. the
file name that is selected, somehow returned back to
Access?

I want to allow users to browse to the MDB file that
serves as the "data" (i.e. backend) database without
naviating through the File|Get External Data|Link Tables
menus. I want to allow users to select the MDB directly.
I then have code to handle the linking of the tables
within the chosen MDB file.

As always, thanks for any assistance.

Kelly

 

[Allen Browne]

It is an API call. Copy the code in this link:
http://www.mvps.org/access/api/api0001.htm

 

[Kelly]

Crikey that was easy! Goodonyamate!!! Thank you very
much.