Stored Procedure

[deodev]

I have a stored procedure on the SQL server -

I created a Access database linking some tables from the database on the
server.
How can I execute the stored procedure from Access.

If I create the query in Access it either takes a long time or the ODBC
timeout.

 

[Van T. Dinh]

Use a Pass-Through Query (in Access MDB) with the SQL

EXEC dbo.YourSP ...

to execute sp in the SQL Server.