Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sp with Access Database

Status
Not open for further replies.

amal1973

Technical User
Joined
Jul 31, 2001
Messages
131
Location
US
Hello....
I would like to know if it is possible to have Stored procedure on the sql server and run them from an Access database linked with an ODBC CONNECTION to the SQL Server ... And the way to pass on parameters....
thanks a million
amal
 
Check out this thread it addresses this question

thread181-27567
 
In Access you can create a pass-through query. The pass-through query can execute a stored procedure. When you have a query design Window open select Query | SQL Specific | Pass-Through. You set the ODBC connection string in the query properties.

See the following article about passing parameters from Access to SQL Server.


I suggest reading about pass-through queries in Access help. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Thank you all . i did work
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top