Hello I am working on an Access Project which works great on my computer. This database is placed on a server which others have access to open it and work with the forms and reports ONLY! 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. :)

slypunk

__________________
slypunk

It's probably down to the ODBC connection to the SQL server, it needs to be set up on each machine used to access the database.



There are two secrets to success in this world:
1. Never tell everything you know

Where can I go to verify that? I went to the Enterprise Manager and I checked their permissions and it looks fine to me.

THanks

slypunk

Ok I'm at the ODBC Connection do I have to go to each machine and set up the same ODBC Connection? I'm a little cofused.

Thanks

slypunk

Well, you could do each machine individually, or you could use the ODBC connection manager to create a file-based connection, and link to that from the Access db (make sure that the file is located somewhere everyone can access it). It will probably mean re-creating the connection in Access too, but that's less hassle that going around each user's machine.


There are two secrets to success in this world:
1. Never tell everything you know

So because of this I cannot use stored procedures as the record source for forms and reports? Because when I use views(which I am not very fond of) as the record source it works fine on the other computers.

slypunk

This is a known problem. What is your Access version and service pack version. You may need the latest service pack installed on all computers.
How does the name of the stored procedure look when you open the adp on the users machine? any charachters in front of the name of the sp? if yes, that is the problem.



Sal

It's Microsoft Access 2000 (9.0.2720) and yes on the other machines the sp may say for example (subEstimatePaymentLog;1(dbo))and on mine it says (subEstimatePaymentLog). Why is that??
slypunk

I'm sorry it's version 5.0.2195 Service Pack 4 Build 2195

slypunk

all of your users need the latest service pack. I am not sure what it is. That should fix your problem.



Sal