Re: Access 2002 Help required please......

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

From: Simonglencross (simon_glencross_at_hotmail.com)
Date: 11/07/04 

Date: Sun, 7 Nov 2004 16:43:49 -0000

Joan,

Whats a RWOP query? you've lost me a little here.

Simon

"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:ek1yKsNxEHA.2016@TK2MSFTNGP15.phx.gbl...
> Simonglencross wrote:
> > Joan is there any way I can implement this without have to scrap the
> > forms which I have done and starting again?
>
> There is no need to delete your existing forms and start over.
>
> I'll assume your forms are based on tables. Create a RWOP query for each
of
> your tables. You can set the run permissions property of the query in
> design view to Owners. This will give you a SQL statement like:
>
> SELECT * FROM Orders WITH OWNERACCESS OPTION;
>
> Change the recordsource of your form to the query. In design view of your
> form, show the field list and drag the new OwnedBy field from the list to
> your form. Set this control's default property to =CurrentUser() and hide
> it if you wish.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>

Relevant Pages

  • Re: Access 2002 Help required please......
    ... Whats a RWOP query? ... >> Joan is there any way I can implement this without have to scrap the ... You can set the run permissions property of the query in ... > design view to Owners. ...
    (microsoft.public.access.security)
  • Re: RWOP query with parameters
    ... I was doing just that before I implemented security but now I ... I had to create a RWOP query and save it in order for the ... Ditto for the ... Thanks Joan! ...
    (microsoft.public.access.security)
  • Re: Access 2002 Help required please......
    ... You can set the run permissions property of the query in ... design view to Owners. ... Joan Wild ...
    (microsoft.public.access.security)
  • Re: Access 2002 Help required please......
    ... You can set the run permissions property of the query in ... design view to Owners. ... Joan Wild ...
    (microsoft.public.access.tablesdbdesign)