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

[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<param eters>'.
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