Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This is about linked queries, not linked tables. With no linked tables, the Linked Table Manager is disabled.

I know how to see the connection of a linked query, linked to SQL Server:

?CurrentDB.QueryDefs("create").Connect

"ODBC;DRIVER=SQL Server;SERVER=PRODSERVER;DATABASE=proddatabase;Trusted_Connection=Yes"

I need to change the server name in the connection.

I tried in the Immediate window

CurrentDB.QueryDefs("create").Connect = "...test server name..."

but that did not change the connect property.

How do I change the connect property?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.