Way to debug stored procedure thru adp?

  • Thread starter Thread starter EManning
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top