Program linked tables from multiple databases

[Terri]

I am using Dev Ashish's "Relink Access tables from code" which works
wonderfully but I would like to link tables from a second database also.

I created a seperate database for staff tables so they can be used in
multiple databases and would like to link these in.

How can I specify two (or more) different back-ends?

These discusion groups have been a huge help. Thank you so much!!

Terri

 

[Marshall Barton]

I am using Dev Ashish's "Relink Access tables from code" which works
wonderfully but I would like to link tables from a second database also.

I created a seperate database for staff tables so they can be used in
multiple databases and would like to link these in.

How can I specify two (or more) different back-ends?

You might want to take a look at David Fenton's relinker.
It handles multiple backends and they do not have to be all
the same kind of file.

http://dfenton.com/DFA/download/Access/Reconnect.html