Forum Discussion

null barryh4's avatar
null barryh4
Copper Contributor
May 29, 2020

How is this Access DB Linked to MSSQL?

Hello,  I am migrating some MSSQL databases to a new server and have to update any connections to point to the new server. One of the the connections is from an MS Access application. All of the tables in Access are direct links to the MSSQL database. It is not using local or system DSN. Anyone that opens the Access database from any computer can use it without setting any local DSN. I assumed it was n the VB code but I have been searching and have not found any connection strings. Every table has the connection string in it attributes, but I have not figured out how to edit it. I have attached a couple images.  I feel like editing the connection string is something simple but so far I cannot figure it out.

Thanks

Resources