Using Stored Procedures

[fogal]

I have an Access .mdb front end database and have a sql 2000 backend. I have created stored procedures in the Sql Server for my database. How do I run these stored procedures from MS Access. Can I link them to forms etc...
I have read articles that talk about using sql pass through queries, but need more information on hoe to use stored procedures and views with access mdb's.

 

[fogal]

So far I've found:
create a sql pass through query
save odbc connection in properties to the sql server
then type:
Exec nameofstoredprocedure parameter1, parameter2 etc....

i.e where parameter is for eg what to insert if my sp is an insert sp.
The sql table is then updated, but access returns eror msg because no records returned. If you set return records property to false then an error msg occurs

 

[cmmrfrds]

How are you running the pass-thru query, show the vba code you are using.

SQL Server will return an informational for each insert and normally you don't want to deal with these. To turn off
Set NOCOUNT ON in your stored procedure.