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