[AccessD] Stored procedures from Access

Martin,

As soon as I try to set the cmd.ActiveConnection = cnn I get 
an error:

Requested operation requires an ole db session object, which 
is not supported by the current provider.

That is when modifying Charlotte's code with your modifications.

John W. Colby
www.ColbyConsulting.com


Martin Reid wrote:
> 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