Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using NT password to protect access db(Windows NT)

    Hi

    I need to add security to a mainfolder that contains a .mdb file and some other subfolders which contain Word docs.. I was wondering if its possible to force the user to log into the mainfolder using their NT username & password. They will already have logged into NT at this stage.....

    any help greatly appreciated

    tia Sheila

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: using NT password to protect access db(Windows NT)

    The way it's usually done is to have the network administrator create an NT group, give that group full permissions in the main folder (and by default to its subfolders), and revoke all permissions in the main folder from the standard user group (Domain Users). Add the users that need to be able to use the database to the newly created NT group.
    There seems to be little point in having users that have already logged in to Windows NT log in to a specific folder with the same user name and password. It doesn't add an extra level of protection, does it?
    If you want to secure the database itself, consider using Access security.

  3. #3
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using NT password to protect access db(Windows NT)

    Thanks for your help as always Hans

    I don't know about adding any extra security to the folder or not, but the validation folks want it!! Time lines etc are strictly adhered to, with regards to changing passwords, expiry after 3 months, not using a previously used password, etc. Does Access automatically support that kind of thing or would I have to code it?

    regards Sheila

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: using NT password to protect access db(Windows NT)

    Hi Sheila,

    In Windows NT, the network administrator can enforce expiration of passwords etc. Once it has been set, the operating system takes care of it automatically.

    Access security is different. You can create users with a password, and give them permissions to selected parts of the database, but there is no built-in mechanism to let passwords expire etc. You would have to code all that. But it seems rather over the top to try and duplicate the security NT offers.

    Windows NT security is meant to ensure that only certain people have access to a computer and to a folder. If people don't have the necessary permissions on the folder, they can't even see the database, let alone use it; the same holds if their password has expired.
    Access security is meant to ensure that only certain people can update data etc. within a database.

  5. #5
    Lounger
    Join Date
    May 2003
    Location
    cork, Ireland, Republic of
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using NT password to protect access db(Windows NT)

    Thanks again for your help Hans -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •