Linked Tables in Access pointing to MSSQL server

[dwjongbloed]

We have a third party application that uses an Access front end but the tables in Access are pointed to our MSSQL Server. I have no idea how these are pointed to our server and am looking for any help I can get to figure this out. We are going to be upgrading our servers and I need to know where to fix this connection string out as we will be assigning the new server a differenty name.

[nico5038]

You can open the linked tables in desing mode and then check the properties.
In the properties the connection string will be visible.
For changing them to a new address you can use the Tools/DatabaseUtiliti es/Linkedtable manager...
Just check the "Always prompt for new location"

Nic;o)