Access & SQl Server with ODBC

[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.

 

[Douglas J. Steele]

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

 

[Dirk Goldgar]

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

See this thread on Google Groups:


http://groups-beta.google.com/group...read/thread/72daa75bc38cd594/3aefdb1e1ef17874

 

[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)