Access & SQl Server with ODBC

J

JuanPi

I am searching general information about Access & SQL Server with ODBC, how
to call to a store procedure from access, ...
¿Any webpage or tutorial?

Excuse my bad english.

Thanks.
 
D

Douglas J. Steele

To call a stored procedure, you need to create a pass-through query that
invokes the SP.
 
D

david epsom dot com dot au

we did it like this:

dim qdfODBC as dao.querydef
Set qdfODBC = dbCurrent.CreateQueryDef("")
qdfODBC.Connect = lstrHeaderLine1
qdfODBC.SQL = lstrHeaderLine3
qdfODBC.ReturnsRecords = False
qdfODBC.Execute DAO.dbFailOnError

This example dynamically creates a temporary "query",
turns it into a passthrough query by setting the connect value
sets the SQL (stored procedure name),
sets 'ReturnsRecords = false' (necessary if the stored procedure does not
return records),
and executes the stored procedure.

(david)
 
Top