How do I call a SQL Server Stored Procedure from an Access Report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just converted my Access tables to SQL Server tables and wish to continue to
use Access as front end. Reports are extremely slow so I wrote a Stored
Procedure on Server side. How do I launch it from the report in Access?
 
You should be able to select the recordsource and set it to the SP... I
haven't tried this with an MDB, but have successfully done this with an ADP
(Access Data Project).

HTH,
Drew
 
Back
Top