Hello I am working on an Access Project which works great on my computer. This database is placed on a server where users can access it. However I'm testing this on one of the user's computer and I noticed that the only forms and reports that are not working are the ones whose record source is a stored procedure. Am I doing something wrong? I cannot figure it out. Please if anyone can help me I'd greatly appreciate it. Please view this message I sent back in January.

Thanks

http://p2p.wrox.com/topic.asp?TOPIC_ID=8621

slypunk

slypunk

__________________
slypunk

have you give the users execute rights to the procedures? Are you using the dbo login as well to ensure that it is not a security issue?
It is more likely a security issue if it was not the SR issue.



Sal

Do I check this by going to the stored procedure in the Enterprise Manager right click go to properties then permissions. If so, I have made sure that each user can execute these sps. What also confuses me is how some pcs receive the error of "The operation on the No such interface supported object failed." I do not know what other option is left. :(

slypunk

I ran into the same distribution problem with stored procedures in combo boxes. I had to place dbo. in front of my stored procedres and it worked fine.

dbo as in for example Employees; rename it to dboEmployees?

slypunk

The original stored procdure(SP) name was prcCrsNum but when the adp front end was transferd to a user's PC the stored procdure name had dbo following it. So I went into the form and renamed the row source to dbo.prcCrsNum and it worked. I'm pretty new at this and it may be the wrong way but it works for now.

So am I but you know what I tried it and IT WORKED! Thank you very much. FINALLY this took me months to figure out and I got it to work! THank you

slypunk

Ok question: It worked on one computer but not on the others? Does that mean I have to go to each machine individually to change the sps to dbo.?

slypunk

I distrubute the access front end to each user. When i make changes i email them a new copy and have them delet the old one. This way they all have the same version.

Create a table with the latest version number. then create another exe either in VB or even access. Put a splash form just for looks and when it loads have the form check the table to see if there is a newer file in the network. If the there is, do a filecopy. do a search on this forum for filecopy or copyfile, i gave someone else all the steps for this about 2 months ago.

Remember fully qualify your sql code with ownername.object name syntax.



Sal