Store Procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I call a stored procedure from Access and make that a records source
for a form or report?
 
Try this
1. Create a passthrough query , empty

run this code:

Dim db As Database , MySet As Recordset , myqs As QueryDef

Set db = CodeDb()
Set myqs = db.QueryDefs("QueryName")
myqs.ReturnsRecords = True
' Define the execute line for the SP
myqs.sql = "DECLARE @R int EXEC SPName select @R "
Set MySet = db.OpenRecordset("QueryName")
If not MySet.Eof then
your code...
end if
 
You must log in or register to reply here.

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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Stored Procedure 1
parameter passthrough query 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Stored SQL Procedure from Access? 1
Using Variable as criteria 4
SQL Delete Stored Procedure 2
Stored procedure as row source for a combo box 4

Back
Top