By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

Linked Tables in Access pointing to MSSQL server

P: 1
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.
Feb 23 '09 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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/DatabaseUtilities/Linkedtable manager...
Just check the "Always prompt for new location"

Nic;o)
Feb 23 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.