How to invoke a sql stored procedure from ACCESS

  • Thread starter Thread starter Ray_s
  • Start date Start date
R

Ray_s

Hi,

what shall I (the dba) do in order to allow a user (using Access database)
to execute a sql server 2005 stored procedure?

Thanks
 
Ray_s said:
Hi,

what shall I (the dba) do in order to allow a user (using Access
database) to execute a sql server 2005 stored procedure?

Thanks
Click to expand...

Nothing, besides providing the login account the Access user will use to run
the passthrough query from Access that runs the stored procedure.
 
I apologize for re-asking.
not a 100% sure about what you meant by to run the passthrough query
how to make the Access query a PassThrough one?

Thanks
 
Ray_s said:
I apologize for re-asking.
not a 100% sure about what you meant by to run the passthrough query
how to make the Access query a PassThrough one?

Thanks
Click to expand...
 
Using Access 2003: from the query designer with a new query, no table
selected. In the menu, select Query, then SQL Specific, then Pass-Through.


Vanderghast, Access MVP




I apologize for re-asking.
not a 100% sure about what you meant by to run the passthrough query
how to make the Access query a PassThrough one?

Thanks
 
In the Query menu, select SQL Specific, then select pass-through.
Then enter the connection string or click the ellipsis button to select
an ODBC DSN
 
Great! thank you Bob and Michel.

Bob Barrows said:
In the Query menu, select SQL Specific, then select pass-through.
Then enter the connection string or click the ellipsis button to select
an ODBC DSN
Click to expand...
 
Back
Top