Linking External Tables to Current Database

[jadown]

Hi All,

I was wondering if it was possible to link random external tables to the Active Database through VBA. I would like to run the code that would open up a dialog box that would let the user select the database as well as the tables within that database that the user can select to link to. I am able to select the database and but not able to select the actual tables. The tables will be random so I can't make a constant statement for a specific database.

 

[spikepl]

Please explain the context and the need this is meant to satisfy. Users are normally not to be given access to tables but forms only, which is difficult to do with varying tables.