SP in Subform Returns Empy Box for Some Users

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
First, make sure that everyone is using his/her own copy of the ADP file and
take the precaution of decompiling the file directly on the user's machine
before using it. For instruction on how to decompile an ADP project:

http://groups.google.ca/group/micro...lserver/search?q=decompile&start=0&scoring=d&

Second, maybe you have a schema recognition problem, so use dbo. everywhere
(all tables and views in the SP and for the name of the SP itself) and make
sure that you have set the Record Source Qualifier to dbo in the property of
the form.

Third, if this doesn't work, then take a look with the SQL-Server Profiler
to see what's Access is doing. Maybe your SP is called with some unusual
parameter(s).

Finally, reinstalling Access is probably a loss of time but make sure that
the latest services packs for Office has been installed on all machines;
especially for A2000 because the automated updating process of Windows won't
apply the service packs for these older versions.
 
Back
Top