By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,835 Members | 986 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,835 IT Pros & Developers. It's quick & easy.

Profiler shows 'Select * from "<stored procedure>"' ...

P: n/a
HJ
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 'Table/View/StoredProc' row source type.
The row source itself is a stored procedure.

When an administrator opens this form, he sees data in the list box.
Profiler shows a correct command 'EXEC <stored procedure<parameters>'.
That is allright.

When a non-administrator opens this form, he sees an empty list box.
Profiler shows an incorrect command 'SELECT * FROM "<stored procedure>"'.
The user is a member of the db_owner role.

This is why I now believe that this an Access problem and not an SQL Server
problem. Has anyone ever experienced something like this and how do I solve
it?

TIA,

HJ
May 22 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.