Linking Tables at Runtime??

[Ant]

Hi All

I have a front end and different back ends. The back ends
are all identicle in structure. I want to be able to give
the user a choice when they open the front end as to which
back end they whish to conecct to and then link them to
the relevant back end.

Can anyone offer advice on the best way to do this?

Regards,

Ant

 

[Cheryl Fischer]

You might want to start with the code found at the following link:

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

 

[Peter De Baets]

Ant,

We have a free table linking utility that may help at
http://www.peterssoftware.com/tlk.htm

Hope this helps,