Way to debug stored procedure thru adp?

E

EManning

Using A2K. I've got a weird problem where if I execute a stored procedure
directly, it works fine. If I execute it thru VBA, it does not. It returns
the wrong set of results. In fact, it returns the results of another sp but
that sp is named completely different from this. Is there anything I can
do, besides the debug feature in VBA, to ensure the correct sp is being
executed?
 
S

Sylvain Lafontaine

Did you have refreshed (F5) the Tables and the Queries window?

You can use the Profiler on SQL-Server to see whats Access is doing.
 
E

EManning

Thanks for your reply.

Found the problem, but the solution was weird. The VBA coding executes 3
stored procedures, one after the other, all with the same parameter. I
noticed that the 2nd stored procedure did not return a result set when it
should have returned one row. I misspelled a table name in this sp. After
I corrected it, both it and the sp I posted about worked just fine. The sp
I posted about was the 3rd sp to execute so maybe the failure of the 2nd
affected the 3rd.
 

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
ADP Update Query does NOT update ! 3
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Execute a stored procedure asynchronously 2
Create a stored procedure from VBA in order to use DoCmd.OpenStoredProcedure with arguments 1
the procedure executed successfully but did not return records 5
Access can't greate stored procedure 1
'The stored procedure executed successfully but did not return any records' 4

Top