473,499 Members | 1,525 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stored Procedure Not Working For End User

82 New Member
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.
Apr 16 '14 #1
5 1243
Rabbit
12,516 Recognized Expert Moderator MVP
They probably don't have permission to execute the stored procedure.
Apr 16 '14 #2
barbarao
82 New Member
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.
Apr 16 '14 #3
barbarao
82 New Member
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?
Apr 16 '14 #4
Rabbit
12,516 Recognized Expert Moderator MVP
How is the stored procedure being invoked? Did you test it from her computer yourself?
Apr 16 '14 #5
barbarao
82 New Member
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.
Apr 16 '14 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
22090
by: dinesh prasad | last post by:
I'm trying to use a servlet to process a form, then send that data to an SQL server stored procedure. I'm using the WebLogic 8 App. server. I am able to retrieve database information, so I know my...
3
2528
by: Gary Besta | last post by:
I am trying to add a simple case statement to a stored procedure or user defined function. However when I try and save the function/procedure I get 2 syntax errors. Running the query in query...
4
2262
by: Vithar | last post by:
I built a database by using a generated script from the original database. It built the System Store Procedures as User type. How do I change them back to System type?
5
8896
by: Raquel | last post by:
Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP. I am new to stored procedures. The stored procedure code I am using is at:...
3
6383
by: Jim Andersen | last post by:
Just to let you know, and to help any future sorry sods who gets trapped in the same black hole...... You can't just copy/move a working sql-statement into a stored procedure. Working with a...
0
2347
by: mongolian | last post by:
Hello, I am trying to execute an Extended Stored Procedure in a User Defined Function I wrote. It really is quite simple but I get an error saying "Only functions and extended stored procedures...
1
4281
by: gregoryday | last post by:
I am battling to get a stored procedure to build: I have a stored procedure working in SQL Server 2000, and now need to port it to DB2. I will be accessing the stored procedure via VB.NET. The...
0
1353
by: HJ | last post by:
Hi all, I am experiencing a weird issue and I hope you can help. We are using a Microsoft Access 2003 project (.ade) with an SQL Server 2000 database. One form contains a list box with the...
6
2457
by: HJ | last post by:
Hi all, I am experiencing a weird issue and I hope you can help. We are using a Microsoft Access 2003 project (.ade) with an SQL Server 2000 database. One form contains a list box with the...
5
2283
by: OtheymAverian | last post by:
I am trying to call a stored SQL procedure while either passing or accepting a used inputted parameter. Currently I have a variable coded to accept the number I need to pass, but I do not know how...
0
7130
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7007
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7171
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7220
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5468
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4918
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4599
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3090
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
295
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.