Stored Procedure

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

Guest

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.
 
Use a Pass-Through Query (in Access MDB) with the SQL

EXEC dbo.YourSP ...

to execute sp in the SQL Server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
SQL Server Stored Procedure timeout 3
Oracle Data Provider for .NET: Connection request timed out 0
Report refresh crashes Access 2007 1
SQL ADP Reports not working due to Authentication rights 2
ADP Reports cancell with no error because sql server takes to long 2
Report not printing all groups 1

Back
Top