Opening table in adp file produces no records

D

Don Bouchard

I have an SQL d/b that I like to access via an ADP file.
I have about 100+ tables in the SQL database. On a few
tables, 2 at least, when I double click on them to open
the records I get the following message in a small dialog
box: "The stored procedure executed successfully but did
not return records." Sometimes, I get a different
message complaining about the table's primary key being
null. Other tables work just as expected. The only way
for me to see the data is thru Query Analyzer where all
seems to be OK.

Any ideas?

Many thanks for any help on this.
 

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

Top