How do I create a passthrough query in access using a DSN-less connection?
15,048
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
Related videos on Youtube
01 : 40
Speeding up DELETEs with a Pass-Through Query in MS Access
05 : 02
Access: Designing a Simple Query
15 : 44
Microsoft Access 2013 Tutorial - Query Design
02 : 06
MS Access Pass Through Query
03 : 41
Creating a Parameter Query in Access
02 : 18
How to create a simple select query in Microsoft Access
04 : 06
Creating DSN for MS Access Database
30 : 21
SA: Stored Procedure, Pass Through Query or ADODB?
44 : 48
Access 2016 - ADVANCED QUERIES, CROSS-TAB QUERY, REPORTS AND FORMS
18 : 34
How to Use a Pass Through Query in MS Access - SQL Server Example
06 : 21
How to Build a Simple Parameter Query in Access
Author by
Brett G
Updated on September 15, 2022Comments
-
Brett G over 1 year
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.
-
Brett G almost 12 yearsAhhh, under "ODBC Connect Str". How easy, but so hard to find. Thanks!
-
namko over 5 yearsWill someone explain why this is the case? Shouldn't the Query pass through easily with the DSN-less connection?
