Open Dialog changes linked DB name, but not table name

[daffy333]

Good evening,

I am planning on developing a tool that draws information from a number
of tables in a BE database, and have come upon a conceptual problem
(meaning I can't figure how to put my concept in action):

What I would like is to have on startup a Open File dialog box come up,
that users can use to browse to their respective BE, and have all of
the tables linked to my FE tool. However, while all of the table names
and field names are standardized, the BE database names are individual
to every user.

I am a self-taught Access user and therefore I fear that what I am
asking for is probably beyond my capabilities. However any help that
you are able to provide would be greatly appreciated, even if it is to
say that it is most certainly beyond my means.

Thank you in advance

 

[Van T. Dinh]

I think you may be able to use the idea & sample code from The Access Web

http://www.mvps.org/access/tables/tbl0009.htm

with a bit of mods.

 

[daffy333]

Yeah, that looks like its way too much for me. Unfortunately I don't
know enough to mess with VB code.

Thanks for the input.