Create a SQL pass through without using an ODBC driver?

[Guest]

Is there anyway in Access 2000 to be able to create a SQL pass through query
without a user having a ODBC driver created in their ODBC connections?

Thanks in advance

 

[Douglas J. Steele]

You can go DSN-less.

The Connect property of the query needs to be set to the appropriate ODBC
DSN-less connection as outlined by Carl Prothman at
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer