Change connection of ADP referenced by another Access database

[jonathan.walker]

Hi,

I have a database that references an ADP. We are moving to a
Development/Test/Production enviroment and to make moving the database
through the enviroments easier. We have been looking into changing the
sql server connection automatically depending which development
enviroment we are in.

I have found code to change the connection of the main adp but the
referenced adp I have had no luck in the groups. I do not even seem to
be able to reference in code which database the referenced database is
connected to.

Hope this makes sense.