"Keith Wilby" wrote:

> "meyerryang" <meyerry***@discussions.microsoft.com> wrote in message
> news:DA59D8A2-904A-4A4E-B665-B92A2540378C@microsoft.com...
> > Is there a way to give Users the ability to add new records to the
> > database,
> > but at the same time prevent them from taking any copies of the tables
> > from
> > it, by importing into other databases???
> >
> > Thanks in advance.
>
> You need to apply user level security.  See my web site for a link to the
> FAQ.  Be warned it is a complex topic and do make regular backups in case
> you lock yourself out.
>
> Keith.
> www.keithwilby.com
>
>

"meyerryang" wrote:

> User Level Security is already applied, however due to the design I have
> simplified the users to a generic "Users Group".  Is it possible to assign
> the Users Group the ability to read, update, and insert while preventing a
> database from pulling tables out of it? 
>
> Thanks.
>
> "Keith Wilby" wrote:
>
> > "meyerryang" <meyerry***@discussions.microsoft.com> wrote in message
> > news:DA59D8A2-904A-4A4E-B665-B92A2540378C@microsoft.com...
> > > Is there a way to give Users the ability to add new records to the
> > > database,
> > > but at the same time prevent them from taking any copies of the tables
> > > from
> > > it, by importing into other databases???
> > >
> > > Thanks in advance.
> >
> > You need to apply user level security.  See my web site for a link to the
> > FAQ.  Be warned it is a complex topic and do make regular backups in case
> > you lock yourself out.
> >
> > Keith.
> > www.keithwilby.com
> >
> >

"meyerryang" <meyerry***@discussions.microsoft.com> wrote in message news:6479EF57-ADBF-4C0E-8D73-70FCC64666C7@microsoft.com...
> Okay, I determined a workeable way is to set the run permissions properties
> of each query as "Owner" and disable all tables permissions.  How do I work
> around setting the run permissions for a sql based query, such as a UNION
> query for example?  Is it possible?
>
> Thanks in advance. 
>
> "meyerryang" wrote:
>
>> User Level Security is already applied, however due to the design I have
>> simplified the users to a generic "Users Group".  Is it possible to assign
>> the Users Group the ability to read, update, and insert while preventing a
>> database from pulling tables out of it? 
>>
>> Thanks.
>>
>> "Keith Wilby" wrote:
>>
>> > "meyerryang" <meyerry***@discussions.microsoft.com> wrote in message
>> > news:DA59D8A2-904A-4A4E-B665-B92A2540378C@microsoft.com...
>> > > Is there a way to give Users the ability to add new records to the
>> > > database,
>> > > but at the same time prevent them from taking any copies of the tables
>> > > from
>> > > it, by importing into other databases???
>> > >
>> > > Thanks in advance.
>> >
>> > You need to apply user level security.  See my web site for a link to the
>> > FAQ.  Be warned it is a complex topic and do make regular backups in case
>> > you lock yourself out.
>> >
>> > Keith.
>> > www.keithwilby.com
>> >
>> >

"Joan Wild" wrote:

> If you open any of your current RWOP queries, you can use View, SQL View to see the SQL statement.  You'll see that the end of the SQL statement has
> WITH OWNERACCESS OPTION;
>
> You'd do the same with your UNION query.
> --
> Joan Wild
> Microsoft Access MVP
> "meyerryang" <meyerry***@discussions.microsoft.com> wrote in message news:6479EF57-ADBF-4C0E-8D73-70FCC64666C7@microsoft.com...
> > Okay, I determined a workeable way is to set the run permissions properties
> > of each query as "Owner" and disable all tables permissions.  How do I work
> > around setting the run permissions for a sql based query, such as a UNION
> > query for example?  Is it possible?
> >
> > Thanks in advance. 
> >
> > "meyerryang" wrote:
> >
> >> User Level Security is already applied, however due to the design I have
> >> simplified the users to a generic "Users Group".  Is it possible to assign
> >> the Users Group the ability to read, update, and insert while preventing a
> >> database from pulling tables out of it? 
> >>
> >> Thanks.
> >>
> >> "Keith Wilby" wrote:
> >>
> >> > "meyerryang" <meyerry***@discussions.microsoft.com> wrote in message
> >> > news:DA59D8A2-904A-4A4E-B665-B92A2540378C@microsoft.com...
> >> > > Is there a way to give Users the ability to add new records to the
> >> > > database,
> >> > > but at the same time prevent them from taking any copies of the tables
> >> > > from
> >> > > it, by importing into other databases???
> >> > >
> >> > > Thanks in advance.
> >> >
> >> > You need to apply user level security.  See my web site for a link to the
> >> > FAQ.  Be warned it is a complex topic and do make regular backups in case
> >> > you lock yourself out.
> >> >
> >> > Keith.
> >> > www.keithwilby.com
> >> >
> >> >
>