Using SQL Server Stored procedures

[sineados]

Hi,

I have exported all my access tables to sql server and created some stored procedures from my access queries. I have a couple of reports and forms that use the access queries and now I would like to update them to reference the sql server ones instead.

Does anyone know if this is possible and how do I do it. The export/import functions seem to only work for tables (or I am missing something).

thanks in advance,
Sinead

 

[mdthornton]

Hi

You need to do this as a pass through query and set your SQL to:

exec myStoredProc

Good Luck,
Mike T