Stored Procs

  • Thread starter Thread starter RK
  • Start date Start date
R

RK

Hello All & Greetings.

I am looking for any info sources for being able to call stored procs from
my Access DB application.All tables are linked to SQL Server 2000 SP3 and
developed using MS Access 2000. I have 2 StoredProcs (for INSERT and DELETE
and TRIGGER for UPDATE.

Any info / links / etc would be very helpful.

Thanks,

RK
 
To Keep it really simple:

if it returns records:
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.ConnectionString = "Connection string for your Sql Server and
Database"
cn.Open
Set rs = cn.Execute("Exec YourProc(param1, param2, etc...)")
' Do stuff with records
rs.Close
cn Close
Set rs = Nothing
Set cn = Nothing

if it does not return records
Set cn = New ADODB.Connection
cn.ConnectionString = "Connection string for your Sql Server and
Database"
cn.Open
cn.Execute("Exec YourProc(param1, param2, etc...)")
cn Close
Set cn = Nothing

Ron W
 
Back
Top