Re: Securing divided database using workgroup (*.mdw) file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Keith Wilby" wrote:

"Jarda Beran" <JardaBeran@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E69E32A9-6C68-4D81-A858-281E7CDBD562@xxxxxxxxxxxxxxxx

Keith,
I've found a lot of interesting information on your website, thank you.
I have one more question - what about linked tables? Do I have to set up
permissions to the data tables for all users in the source (back-end)
database, or just in the front-end? And what if I need to relink the
tables?

What I do is have no user permissions to tables at all and use RWOP (run
with owner's permissions) queries on them. That way, as long as the user
has permissions to the RWOP query, they will inherit those same permissions
on the table(s). Search the help for "WITH OWNERACCESS OPTION" for more
info.

Regards,
Keith.


Keith,
I've heard about RWOP, but I'm not sure how to use it, when I have several
tables, related to each other, and each of them is data source for one nested
form. So I decided to set permissions both in back-end and front-end
databases.
Anyway - thank you for suggestion. Maybe, next time, I'll try RWOP.
Best Regards
Jaroslav
.

Relevant Pages

  • Re: problem with mdw!!!!
    ... Keith there is a step in the wizard asking whether you want to give any ... permissions to the group users and i give no perimissions!!I have a thought ... go in the database because in this mdw the users group has full permissions ... Thanks for your time Keith!! ...
    (microsoft.public.access.security)
  • Re: Backdoor.trojan
    ... "Keith" wrote in message ... > Does anyone know how to get rid of the Backdoor.trojan? ... Administrator account, and even for that one make it read-only permissions. ...
    (microsoft.public.security.virus)
  • Re: Need 2 change user & permission cannot contact creator of cont
    ... Hi Keith, Thanks for your reply. ... I do not have the appropriate permissions. ... I cannot get this info from the originator of the database. ... >>> file Icon thru My Computer. ...
    (microsoft.public.access.security)
  • Re: problem with mdw!!!!
    ... > Keith there is a step in the wizard asking whether you want to give any ... But have you specifically checked what permissions the users group has to ... > go in the database because in this mdw the users group has full ... > Thanks for your time Keith!! ...
    (microsoft.public.access.security)
  • Re: backend security question
    ... I have thought about using RWOP, and actually have all the queries ... >> open the backend and view that table, it has everyone's SS#'s, ... > permissions) queries for all data interaction. ...
    (microsoft.public.access.security)