Pass Through Queries (Access 2002)

[EAI Developer]

Hi. Does anyone have an example of executing a stored procedure in VBA as a
pass through query?

I'm trying to send the query directly to SQL Server 2005 and bypass the Jet
database engine, as the Jet DB doesn't understand some of the SQL keywords
which T-SQL uses.

Thank you.

 

[Douglas J. Steele]

When the Connect field of the QueryDef object has been set, Jet shouldn't
even be looking at the SQL.

How are you trying to invoke the query: by clicking on it, or through code?
If through code, what's your code look like?

 

[AG]

Just create the pass through query and execute it via VBA in the same manner
as you would any other query.
E.G. CurrentDb.Execute "yourqueryname"

If you need to be able to create the T-SQL on the fly check out the
'PassThroughFixup' section in
http://msdn.microsoft.com/en-us/library/bb188204(SQL.90).aspx