SQL Pass Through query requires destination field

  • Thread starter Thread starter nolanmadson
  • Start date Start date
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?
 
See whether using the Execute method of the QueryDef object works any
better.
 
Back
Top