antic
Perch
Hi all,
I'm using an Access 2003 .ADP file to connect to an SQL Server database. Usually it all works fine, but sometimes I get an error when simply trying to open a table:
"Stored procedure executed successfully but did not return any records."
This error does not even go away when I delete the ADP file and set it up again from scratch. Some tables will open up fine, others will result in this error. The tables that give the error seem to always be the same ones, so maybe there's something in the table design that Access ADP doesn't like?
Does anyone else have experience with this problem?
I'm using an Access 2003 .ADP file to connect to an SQL Server database. Usually it all works fine, but sometimes I get an error when simply trying to open a table:
"Stored procedure executed successfully but did not return any records."
This error does not even go away when I delete the ADP file and set it up again from scratch. Some tables will open up fine, others will result in this error. The tables that give the error seem to always be the same ones, so maybe there's something in the table design that Access ADP doesn't like?
Does anyone else have experience with this problem?