CreateQueryDef for a pass through query

[JimP]

How can I do this to execute a stored procedure on a SQL Server db? e.g.

strSQL = "Execute....."
Set qdf = CurrentDB.CreateQueryDef("PassThroughQuery", strSQL)

This produces an error, "Invalid SQL statement, expecting SELECT, INSERT
etc..."

 

[Alex Dybenko]

Hi,
you can to set first a connect property:

Set qdf = CurrentDb.CreateQueryDef("PassThroughQuery")
qdf.Connect = "ODBC;DRIVER=..."
qdf.SQL = strSQL

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[JimP]

Thank you, I had the connect statement after the SQL statement (not before).