Re: New to security have questions before plunging

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


"Keith" <keith@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:d2jmcu$865$1@xxxxxxxxxxxxxxxxxxxxxxxxxx
>> One of the comments stated that I need to create a new MDW for each
>> revision, could you explain why? Is it because on the new revision that
>> you might have new tables, queries, etc and the User Group won't have
>> permission for these?
>
> Got it in one. :-)

That is not true Keith. There is no reason to create a new MDW for each
revision; infact it's undesireable (when to deploy it, you'll wipe out the
users' passwords.)

Remember that the permissions are stored in the mdb not the mdw. The only
reason to deploy a modified mdw (note you wouldn't create a new one) would
be if you added new groups or users.

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: remove user level protection completely from mdb
    ... Granting full permission to users group did the job. ... Your mdw file should reside in a public place and you ... your command line would look like this: ...
    (microsoft.public.access.security)
  • Re: User access on a company intranet
    ... any prompt then what I have set up within my database. ... How do I give them permission. ... The path to mdw would be the path to the mdw you used to secure it with. ... database is in a folder only people in my department can access. ...
    (microsoft.public.access.security)
  • Re: Mdw file not found
    ... We have seen this often enough to be certain that it is a Windows permission ... It is likely that the first person to open the mdb does not have ... Microsoft Access MVP ... showing the full path to Microsoft Access, the mdb file and the mdw ...
    (microsoft.public.access.security)
  • Re: changes in MDW files (network vs. local HD)
    ... What 'security change' did you make? ... that is not stored in the mdw. ... If you make a permission change, you need to copy the changed mdb to your ... another user, working with the same MDW file on ...
    (microsoft.public.access.security)
  • Re: distribution and security
    ... one mdw and from inside of access with the default mdw. ... permission of the user. ... not still listed as the owner of the database object. ... Owners haves rights even ...
    (microsoft.public.access.security)