CreateQueryDef for a pass through query

J

JimP

How can I do this to execute a stored procedure on a SQL Server db? e.g.

strSQL = "Execute....."
Set qdf = CurrentDB.CreateQueryDef("PassThroughQuery", strSQL)

This produces an error, "Invalid SQL statement, expecting SELECT, INSERT
etc..."
 

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

Creating a querydef of a stored proc on Sql Server 8
Invalid Operation on a querydef 2
How to check if a query exists and if it finds to delete 4
Pass Through Queries (Access 2002) 2
Send an Query output with a Email using "sendObject" function 1
Problem with TransferSpreadsheet - memo fiedl gets truncated 1
Any better way to do the query 4
Access to SQL 4

Top