Access project with SQL server : users can't run stored proecdures from forms

[pbedel]

Hi,
I've created an Access project that connects to a SQL server 7.0. When running my .adp the users are able to launch stored procedures from within the Database window but as soon as they try to use forms, that contain the same stored procedures as controlSources, a window pops up saying that the specified recordsource does not exist or couldn't be found.

This problem only disappears if I provide all users with System Administrators rights in SQL Server!

PS. I am using NT authentication

Has anyone got any clues as to what I did wrong ?

Thanks,
Pierre

[rwendel]

have you tried...

databaseInstance.dbo.storedProcedure

Or whoever the owner of the stored procedure is?

dbInstance.<<sp_owner>>.stored_procedure

[pbedel]

whoops,

sorry I'd forgotten I'd posted my question here...

Yes, thanks rwendel, I got it working by prepending each stored procedure with the name of their owner (do not simply accept the choice of stored procedures that Access offers you).