G
Guest
Hi all.
I have created several stored procedures on SQL server and have an Access
ADP linked to them. I wish to have a user double click on the stored procs in
Access to run them. My problem is that some of the stored procs are not
returning records to access. I can run all the stored procs in SQL Query
Analyzer without a problem. It seems that the ones that do not return records
to Access have SELECTs on temporary tables to produce the results.
Does anyone know if this is a known problem in Access?
I have created several stored procedures on SQL server and have an Access
ADP linked to them. I wish to have a user double click on the stored procs in
Access to run them. My problem is that some of the stored procs are not
returning records to access. I can run all the stored procs in SQL Query
Analyzer without a problem. It seems that the ones that do not return records
to Access have SELECTs on temporary tables to produce the results.
Does anyone know if this is a known problem in Access?