Changing the connection information on a linked QUERY in Access 2007

[Lars]

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?

 

[Lars]

I have discovered how to change the connect property. Right click the query name and choose Properties. The properties will display on the right side of the screen, including the connection information.