Linking Tables... (1 Viewer)

[dgoulston]

is there a way i can put a button on a form, which will run a macro/vb code that will allow the user to link a table from another data base to the one they are in...

i have a data base called "userinfo" which has querys/reports but no tables because i want to give it to a client and they link to there table in there database. and use the reports i have created...

there table will be called "usertable"
is there any code that will do the
file -> get external data -> link tables
to bring up the link box? basically a shortcut,,,


thank you in advance.
Darren Goulston

 

[SteveM]

Hi,

I think the following link should lead you in the right direction. I have used this code in a number of databases.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=4930&highlight=link+auto

Steve