Setting recordsource to secured table

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,
I have a form that I am trying to re-use to display data from 2 different
tables and the information is changed in the click event from the menu that
selects the form and it sets the recordsource, label captions, and textbox
sources.
This works fine on my userid (the owner), but there are no permissions on
those tables for other user groups. I thought I could get around that using
the "with owneraccess option", but it doesn't seem to be working.
I have confirmed that the owner of both tables has full permissions.
What am I doing wrong?

Thanks,
beth

Here is a snippet of the code that pertains to this question.

Private Sub cmdCategories_Click()
DoCmd.OpenForm "frmSingleEntry"
With Forms!frmSingleEntry
.RecordSource = "SELECT Categories.Category FROM Categories ORDER BY
Categories.Category WITH OWNERACCESS OPTION;"
.Caption = "Categories"
.lblTitle.Caption = "Categories"
.lblItem.Caption = "Category"
.txtItem.ControlSource = "Category"
End With
Exit sub


.

Relevant Pages

  • Re: Object permissions
    ... Who is the owner of the query? ... permissions does the owner have on the underlying tables? ... does the user have on the query; ... to 'owners' in the sql statement each time the code runs, ...
    (microsoft.public.access.security)
  • Re: Security without signon
    ... I cannot change the owner of the ... rather than inherited permissions by virtue of group membership. ... the default Admin user is the same across all mdw files. ... accounts plus the account for my SuperUser and the account for my SuperGroup, ...
    (microsoft.public.access.security)
  • Re: Permissions denied ifcfg-eth0
    ... network-functions because it wants to access ifcfg-eth0) ... Copy the EXACT error messages. ... is for the owner of the file. ... Further, processes running _as_root_ ignore permissions, because root is ...
    (alt.os.linux.redhat)
  • Re: NTFS folder permissions - Creator Owner issue (I think)
    ... From what you're telling me an owner has rights that cannot ... which seems to include the right to change permissions whether we ... >> the grant to Creator Owner becomes a real grant to the creator or the ...
    (microsoft.public.security)
  • Re: Shared folder security tab...Windows 2003 server
    ... A user that creates a file/folder will be the owner of such and be able to ... change permissions on them even if they have no explicit permissions. ... security tab on all the client computers. ... While this worked for local folders ...
    (microsoft.public.windowsxp.security_admin)