Select Passthru query for multiple users

[BR]

I have the need to be able to have many users open a access db that only
contains a passthru query to a sql server. I do not however want to have to
visit each machine to install a DSN entry. Is there a way to do this?
My SQL7 server is named Radical if that will help in the coding. I have read
about using dnsless queries but do not know where to place the connection
strings.

Thanks in Advance.

 

[Douglas J. Steele]

Set the Connect property of the pass-through query to one of the ODBC
DSN-less connection strings Carl Prothman has at
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer

(If you end up wanting to create linked tables without a DSN, see
http://www.accessmvp.com/djsteele/DSNLessLinks.html )