Stored Proc works in SQL2000, but not in adp file

[AdamP]

I have an adp form that calls some stored procedures that contain update queries. Most of these work, but one only works when I run it in the SQL query analyzer, not when I call it from the adp form. I don't get any errors. Any ideas? Thanks in advance.

 

[cmmrfrds]

Does it require parameters and how are you passing the data to the stored procedure. Probably help to show at least the first part of the sproc.

 

[AdamP]

Well, I figured out that my syntax was wrong in the code where I called the stored proc. Sorry.