Link Tables on demand

[salsito]

I have a back-end and a front-end Db,for testing and other
reasons i want to be able to change the table-links at runtime
via a screen asking which db-file to use.
By the way is it possible that he automatically selects all
tables in one go?
(i work on different computers and networks)

Can somebody help?

Thanks

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

[Brian Beers]

You can loop through allyour tabledefs and change the connect string.

Dim td as TableDefs
For Each td in CurrentDB.TableDefs
Select Case UserChoice
Case 1
td.Connect = ConnectString1
Case 2
td.Connect = ConnectString2
Case 3
td.Connect = ConnectString3
End Select

Next

Brian Beers

salsito wrote in message <083a7ec0...@usw-ex0102-014.remarq.com>...

[Brian Beers]

You will also need to add:
td.Refreshlink
immediately following the "td.Connect" change.

Brian

Brian Beers wrote in message ...