how can i link different database?

[Guest]

hello, i want to use a form to link different database.
i should make a button(in front of it, there will be a give path) and when
user press this button, Access should look in the given path to find all
database there, and then user will choose one of them, another button use to
link the database which user choosed into Access, and then user can do query,
get forms or any other stuff .
all the database in the given index have the same structure only different
data in them.
how can do it? i mean how to write program to those buttons, thanks

 

[George Nicholson]

Start with:
http://www.mvps.org/access/tables/tbl0009.htm
"Relink Access Tables from code"

and see if the ideas behind it points you in a worthwhile direction.