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.
 

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

How to Change criteria on a saved query using VBA 0
Pass Through Queries (Access 2002) 2
record set for pass through query 1
Running a stored-procedure by pass-through query 0
Page numbering with Merged Document and IF statements 1
Trusted Connection in Pass-trough query... 4
Getting request that a query have a destination field 3
Append Passthrough Query Results to Local Table 2

Top