Using Stored Procedures With Access Data Project

[Doc]

SQL backend - Access front end. Have built several SQL Stored Procedures
into database, but have not found how to pass the parameters required by the
Stored Procedures.

I know this has got to be simple, but I can't figure it out on my own. How
do you base a from on a stored procedure by passing parameters without the
annoying pop up box asking for the parameters?

 

[Sylvain Lafontaine]

First, the best newsgroup to ask about this kind of question would be
microsoft.access.adp.sqlserver.

In your cases, there are two main methods. The first one is to build an
t-sql string that will call the SP with its parameter using the EXEC
statement:

sql="EXEC MySP Parm1, Parm2"

The second method is to use the InputParameters properties to pass the
values of the parameters. When using this method, defining the
ResyncCommand as well as the UniqueTable properties is a good idea. Search
Google for InputParameters:

http://groups.google.com/groups?q=inputparameters&start=0&scoring=d&ie=UTF-8&oe=UTF-8&

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[boonying]

--

Thanks & best regards,
MR.BOONYING P.

Inspectorate (Thailand) Co., Ltd.
14 Moo 16 Bangna, Bangna
Bangkok 10260
E-mail: (e-mail address removed)