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
 
Back
Top