SQL Pass Through query requires destination field

N

nolanmadson

I've created a SQL pass through query which calls a stored procedure on
the Teradata database with which I'm working. I can execute the query
directly which successfully calls the stored procedure. However when I
attempt to call the query in a VBA routing using DoCmd.OpenQuery, I get
an error message that at least one destination field is required. How
can I run a query in VBA that doesn't have a destination field?
 
D

Douglas J. Steele

See whether using the Execute method of the QueryDef object works any
better.
 
Top