Change source of ODBC data

[Alan Cannon]

I have an Access 2013 database that includes among its tables 4 externally linked ODBC tables in a SQLServer DB. They are linked tables, not imported. There are also relationships between these tables for some of the queries and reports in the Access DB. I need to make a copy of the database and change the source of the ODBC links to a different SQLServer DB. I have not been able to figure out how to do that without rebuilding the links with a new source definition created from scratch. Is there a way to edit the links to avoid this?

Any help will be greatly appreciated. I am going to need to do this for each new project we initiate.

Thanks,
Alan

[ssanfu]

Don't know if this will help, but you might look at:

The Connection Strings Reference
http://www.connectionstrings.com