G
Guest
To whomever can provide assistance,
I have 3 roles of permission for my access database and every user falls
into 1 of 3 roles. Every user can see every form when the record source is a
table; however, some users can't see a subform that receives parameters and
has a stored procedure as a record source. The subform just shows up as a
big white box, like the sp didn't return any records. Like I said, not all
users are experiencing this issue. Other users assigned to the same role
have no problem, so I know the code is right. Just to test, I had one user
who was experiencing the problem access the sp directly in design view and it
ran with no errors and he could see all records. My plan is to try to
reinstall MS Access on their machines, but I'd like to know if anyone has
seen this problem before. I've confirmed that 2 of the users having the
issue are running MS Access 2000 and I'm running MS Access 2003.
I have 3 roles of permission for my access database and every user falls
into 1 of 3 roles. Every user can see every form when the record source is a
table; however, some users can't see a subform that receives parameters and
has a stored procedure as a record source. The subform just shows up as a
big white box, like the sp didn't return any records. Like I said, not all
users are experiencing this issue. Other users assigned to the same role
have no problem, so I know the code is right. Just to test, I had one user
who was experiencing the problem access the sp directly in design view and it
ran with no errors and he could see all records. My plan is to try to
reinstall MS Access on their machines, but I'd like to know if anyone has
seen this problem before. I've confirmed that 2 of the users having the
issue are running MS Access 2000 and I'm running MS Access 2003.