Forum Discussion
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
- George HepworthSteel Contributor
null barryh4 It looks like the tables are linked via DSN-less connections. You'll find a good template for managing DSNLess links here. D J Steele DSNLess Links