Re: Why Are "Permission Entries" changed

From: Tim (Tim_at_NoSpam.com)
Date: 03/09/05

  • Next message: Ken Winters: "Re: Why Are "Permission Entries" changed" 
    Date: Wed, 9 Mar 2005 15:56:22 +1300

    If you are setting the permissions on the actual database file then the
    answer is obvious.

    The compression routine works like follows (well, this is how it should
    work):

    MDB ==> Compressed MDB
    MDB ==> renamed temp file (.BAK usually)
    Compressed MDB ==> renamed to original MDB
    The reason for this convoluted approach is that the MDB file does not get
    deleted until there is a known good compressed file in existance - if the
    process fails, it just leaves the original MDB file in place.

    If you indicate you want to keep the backup (depends on the utility) then
    the .BAK stays and will have the permissions you have set.

    Since the new MDB was created from scratch during the first step, it
    inherits its permissions from the file store container it is in.

    The solution is simple: grant the permissions to the containing folder. If
    you are hesitent to do this because of what else is contained in the folder,
    then move the MDB file to a dedicated folder and set the permissions on it.

    Personally, I would raise this as a bug with the software vendors as NO
    software should require the EVERYONE group to have permissions to anything
    (IMHO).

    - Tim

    "Ken Winters" <kwinters@olympus.net> wrote in message
    news:112sjjknte15819@corp.supernews.com...
    >I have an application that requires username "Everyone" to be granted
    >permission for a MS Access database file. But everytime I run the MS
    >Access Repair/Compact tool (to eliminate database corruption and free up
    >space) username "Everyone" is removed from the "Permission Entries" list
    >for the database file.
    >
    > Why? And how can I configure the security on that database file so this
    > doesn't happen?
    > Thanks
    >

  • Next message: Ken Winters: "Re: Why Are "Permission Entries" changed"

    Relevant Pages

    • Re: Why Are "Permission Entries" changed
      ... folder to hold the mdb with the permissions needed set on the folder ... >I am setting the permissions on the actual database file, ...
      (microsoft.public.win2000.security)
    • Re: Permissions
      ... You need to adjust the Windows permission on the folder where the mdb is located. ... All users need read/write/create/delete permissions on the folder. ... I have copied the Database file to the server and set up shortcuts on their ...
      (microsoft.public.access.security)
    • Re: Adding new users to an Access 2002 DB
      ... So the mdb opens when you are using the standard system.mdw. ... It sounds like someone didn't secure it properly, ... When you open it, go to Tools, Security, permissions and check to see what ...
      (microsoft.public.access.security)
    • Re: security only works on my PC
      ... I checked the permissions box and the Users group has no ... Open/Run and open exclusive on database object ... "Joan Wild" wrote: ... properly on the single mdb. ...
      (microsoft.public.access.security)
    • Re: User access on a company intranet
      ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
      (microsoft.public.access.security)