Execute an external SQL Stored Procedure from Access

  • Thread starter Thread starter Luke Ridding
  • Start date Start date
L

Luke Ridding

My problem is this...

I have a product with a secure SQL(v6.5) database that
contains a stored procedure that I need to execute from
within Access 2003, and store the results. I have the
syntax for the query, but how do I tell Access that I am
querying that particular database? Is it a specific type
of query I need to run?
 
Just make the query a pass through (then, the logon, and the database can be
set like any linked table).

Your quey can then be:

Exec yourSp
 
You must log in or register to reply here.

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
How to execute SQL stored procedure from Access 8
Invalid Column Name Sql-Error :Executing a stored procedure 1
From Access how to create stored procedure in SQL server 4
Access 07: Creating Procedures 14
How to execute SQL strored procedure from Access 6
What are the steps to fix damaged MDF files in SQL Server? 0
Access 2007 Detail Not Visible 2

Back
Top