Hi, SQL Backend. Access Front End. I have a stored procedure that works fine for me but when an end user clicks the button that should run the stored procedure they get a message that the procedure can't be found. I know there is a simple fix for this but can't remember it. Hoping someone can help. thanks.
-
-
They probably don't have permission to execute the stored procedure. -
I got some to work by writing the procedure in the Console instead of design view. Having trouble with one more but working on it now. thanks and hope all is well with you.Comment
-
The last one isn't working for the end user. It is available to everyone. She enters info in the two prompts and sees nothing while I see results. Any additional thoughts?Comment
-
How is the stored procedure being invoked? Did you test it from her computer yourself?Comment
-
Hi,
I just rebuilt it and it is working fine. I use it on a button on a form. Thanks as usual for your support.Comment
Comment