How do I run a stored proc using Access

[mjp3333]

I want to use Access to have the operator enter a value for a prompt. This value is updated to a SQL table and I want to run a stored procedure immediately after. How can I do this?

 

[ajaygulati]

write a instead of trigger (if you have SQL 2000). First update the value and then call stored procedure.

 

[mjp3333]

I am pretty much a novice at Access. Do you have an example of how you would code this? I am using SQL 2000. Thank you.

 

[jmeadows7]

Since the SP is run from a as a result of an update on a table, I agree with ajaygulati that a trigger would be the best option - you probably need to talk to your DBA because this becomes an object in the database rather than a client side process.

On the other hand, if you still want to just call it from access, check faq705-2531

Hope this helps.