Results 1 to 8 of 8

Thread: Access Security

  1. #1
    Join Date
    Sep 2006
    Location
    Michigan
    Posts
    4

    Question Unanswered: Access Security

    Does anyone know how to log who connects to an access database, and what information they view/change? Is it possible with access?

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    It's possible, but not out of the box. You'll need to write your own auditing logic.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2006
    Location
    Michigan
    Posts
    4
    How would I go about that?

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I don't know... It's YOUR logic.

    In general, you'll be looking to manually handle table-level operations using disconnected recordsets. You would also be well served by researching mde/ade's as opposed to mdb's/adp's. This provides a significantly more comprehensive level of security and control right out of the gate.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Sep 2006
    Location
    Michigan
    Posts
    4
    Thanks For your Help

  6. #6
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    You'll have to include it as a part of the front end client. With Access, there IS no server process to perform the auditing for you.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Get LoginID

    Using the attachment, you can have a field in your table called: EnteredBy and make the default of that field on the form =getuser(). I also have another post (a few threads back) on this forum which has a better sample of how that would work in action on the form also showing how to store basic changes.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Log system with LoginID

    Here's the sample with a logging type system. As far as viewing data, you could have it write the LoginID to a table when a button is clicked on the main form to the other forms and also write to a field the Primary Key they're viewing.
    Attached Files Attached Files
    Last edited by pkstormy; 09-27-06 at 01:16.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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