Relinking Tables in ADP

[Scott]

I've found many script examples of how to use the API to relink backend
access tables, but does anyone have any links or ideas on how to test/relink
the sql connection or tables for an ADP project file?

I have 5 sql tables attached or linked within my ADP file and when the
connection has changed, Access hits each table and displays the warning
which takes several minutes.

 

[Sylvain Lafontaine]

I'm not sure what you mean by « linked tables » in ADP. You should rephrase
your question.

There is a newsgroup specially for ADP: m.p.access.adp.sqlserver or on
Google:

http://groups.google.ca/group/microsoft.public.access.adp.sqlserver

 

[Scott]

what i mean is with an ADP file, if the connection changes, is there any way
to code the API to allow the user to selection the correct sql server?