calling a sqlserver sproc from access

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / General 2 / February 2007

calling a sqlserver sproc from access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Hellmuth - 27 Feb 2007 06:11 GMT

How would I write code to call a sproc from SQLServer? I connect to SQL
via ODBC. So, let's say the sproc is named sp_test, and my ODBC DSN is
'ABC'.

Thanks in advance.

Reply to this Message

Larry Linson - 27 Feb 2007 07:13 GMT

> How would I write code to call a sproc from SQLServer? I connect to SQL
> via ODBC. So, let's say the sproc is named sp_test, and my ODBC DSN is
> 'ABC'.

Use a passthrough query, with the exact SQL Server SQL.

Larry Linson
Microsoft Access MVP

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.