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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running a stored-procedure by pass-through query 1
Pass Through Queries (Access 2002) 2
how do I execute Teradata macros from excel? 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
How to execute a stored procedure via pass-through query 6
Create SQL Pass through Query Dynamically 1
Trusted Connection in Pass-trough query... 4
record set for pass through query 1

Back
Top