[AccessD] Stored procedures from Access

Currentproject.connection will not work. Its to allow you to share a conenctionalready established with SQL Server and used by Access for examaple in an ADP.

conenction here to SQL  Server 2005.

Dim conn As ADODB.Connection
Dim cmd As ADODB.Command

Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=sqloledb;Data Source=YOURSERVER;Initial Catalog=NWind;Integrated Security=SSPI;"
conn.CursorLocation = adUseClient

Change the server name and the catalog (database)

And you shoudl be good to go.

Martin




Martin WP Reid
Information Services
Queen's University
Riddel Hall
185 Stranmillis Road
Belfast
BT9 5EE
Tel : 02890974465
Email : mwp.reid at qub.ac.uk