Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Security and Multi-User Logging

Discussion in 'Information Technology' started by charles.kendricks@charter.net, Jul 28, 2006.

  1. charles.kendricks@charter.net

    Guest

    I have a couple of questions regarding security for my Access Database.
    First of all I remember reading that if I secure the database with a
    password that it must be opened in exclusive mode so that only one
    person can use it one time. Since I plan to utilize Access in a retail
    setting, I would like to know if there is any way around this
    limitation.

    Also, I would like the ability to track/log which employees are
    utilizing the database at all times. How can I accomplish this. I am
    also willing to utilize a third party application if it will provide
    the capabilities that I desire.
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    implement user level security

    HTH

    Pieter

    <charles.kendricks@charter.net> wrote in message
    news:1148975820.048814.230470@j33g2000cwa.googlegroups.com...
    >I have a couple of questions regarding security for my Access Database.
    > First of all I remember reading that if I secure the database with a
    > password that it must be opened in exclusive mode so that only one
    > person can use it one time. Since I plan to utilize Access in a retail
    > setting, I would like to know if there is any way around this
    > limitation.
    >
    > Also, I would like the ability to track/log which employees are
    > utilizing the database at all times. How can I accomplish this. I am
    > also willing to utilize a third party application if it will provide
    > the capabilities that I desire.
    >
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    charles.kendricks@charter.net wrote:
    > I have a couple of questions regarding security for my Access
    > Database. First of all I remember reading that if I secure the
    > database with a password that it must be opened in exclusive mode so
    > that only one person can use it one time. Since I plan to utilize
    > Access in a retail setting, I would like to know if there is any way
    > around this limitation.
    >
    > Also, I would like the ability to track/log which employees are
    > utilizing the database at all times. How can I accomplish this. I am
    > also willing to utilize a third party application if it will provide
    > the capabilities that I desire.


    I suggest you start by reading
    http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

    Access security is a great feature, but it is, by nature a complex product
    with a very steep learning curve. Properly used it offers very safe
    versatile protection and control. However a simple mistake can easily lock
    you out of your database, which might require the paid services of a
    professional to help you get back in.

    Practice on some copies to make sure you know what you are doing.

    --
    Joseph Meehan

    Dia duit
     

Share This Page