The stored procedure executed successfully but did not return anyrecords

C

cleanwire

Access 2003 adp project, SQL 2000 backend. When I click on certain
tables to view their data, I get the message "The stored procedure
executed successfully but did not return any records". Subsequent
clicking results in nothing at all, not even the message. The tables
affected are those I created recently. They existed in another db, I
generated "create" scripts for those tables in the original db, then
ran the "create" script in the target db. DB owner is dbo just like
the other tables which work fine. Can't use profiler on this
database. Any ideas? Thanks Marty
 
S

Sylvain Lafontaine

I would say that you might have a permission problem on these tables. Of
course, make sure that the owner is still dbo after their creation with the
scripts.
 

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

the procedure executed successfully but did not return records 5
Call stored procedure in SSMS from Access 2016 doesn't work. 0
'The stored procedure executed successfully but did not return any records' 4
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Stored Procedure Error Question 3
ADP Update Query does NOT update ! 3
Returning values from temporary table in stored procedure 2
Stored Procedure call issue from Access Project 1

Top