CODEWITHSUNDEEP
sql-serversql-server-2008ms-accessms-access-2010dsn
Brett G
Brett G

Reputation: 349

How do I create a passthrough query in access using a DSN-less connection?

I'm using DSN-less connections to my SQL Server in an Access database. However, whenever I try to write a "Pass-Through" query and run it, a dialog box pops up asking for the DSN.

Upvotes: 14

Views: 16120

Answers (1)

Fionnuala
Fionnuala

Reputation: 91346

In SQL view, choose properties after you have selected passthrough query and insert an ODBC connect string. For example:

ODBC;DRIVER=SQL Server;SERVER=Server\Instance;Trusted_Connection=Yes;DATABASE=Test

See also: http://www.connectionstrings.com/sql-server-2008

Upvotes: 23

Related Questions