Blank subform and user permissions

From: jokobe (anonymous_at_discussions.microsoft.com)
Date: 10/07/04


Date: Thu, 7 Oct 2004 06:20:59 -0700

Hi ng,

in my database I have set the user permissions for the
tables revokes, the users don't have any permissions. The
queries are working WITH OWNERACCESS OPTION.
The trouble is, in a form with a subform, (both are
pulling the data with owneracc opt) the subform isn't
displayed, only a white space. Setting a different
permission, the subform is displayed.

Any helpful hints?

jokobe



Relevant Pages

  • Re: tab control & user level security
    ... form with some 10 subforms for which permissions need to be checked) ... > - The new system has a main form M with a tab control with form F as a ... That procedure would search the form for subform ...
    (microsoft.public.access.forms)
  • Re: tab control & user level security
    ... form with some 10 subforms for which permissions need to be checked) ... > - The new system has a main form M with a tab control with form F as a ... That procedure would search the form for subform ...
    (microsoft.public.access.security)
  • Setting recordsource to secured table
    ... the "with owneraccess option", but it doesn't seem to be working. ... I have confirmed that the owner of both tables has full permissions. ... Private Sub cmdCategories_Click ...
    (microsoft.public.access.formscoding)
  • Re: Password problem
    ... Let's call that workgroup file, ... No read permission on 'tblmasterfuel' ... WITH OWNERACCESS OPTION has the following meaning: ... use the access permissions of the user who actually owns the ...
    (microsoft.public.access.formscoding)
  • Re: Change User Permissions thru Code
    ... >>Rather than inserting a subform, ... >>Joan Wild ... >>Microsoft Access MVP ... >>> wondering how I could change the permissions in vb to ...
    (microsoft.public.access.security)