The stored procedure executed successfully but did not return anyrecords

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