[AccessD] Stored procedures from Access

Martin Reid mwp.reid at qub.ac.uk
Thu Jan 22 13:52:38 CST 2009


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



More information about the AccessD mailing list