Executing SQL Server 2000 Stored Procs

T

Thom Anderson

I need to develop a small access mdb (can't be an ADP because there needs to
be local tables). Mostly the application will be a few buttons that a user
can click and each button will kick off sql server 2000 stored procedures.
The problem is I am not a VBA programmer. I am a SQL Server programmer.

Can someone provide me with the following code snipits?

1) a call to sql server (non-odbc dsn connections) that executes a stored
procedure and returns a scalar value. The call must have input parameters.

2) a call to sql server (non-odbc dsn connections) that executes a stored
procedure and returns a table, I think it's called a recordset in access.
The call must have input parameters.

Thom
 
Top