Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.