Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Wales
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security (Access 2000)

    I'm trying to put together a secuirty log so that I can see who has been using my dbases and when, which are updated on a roll out version on net worked PC's. So far an absolute blank, can anyone help PLEASE!!

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Security (Access 2000)

    I guess I'd use a hidden form that was loaded during startup. In it I'd record the UserName and date/time in a table in backend database. And when the database is closed, the hidden form will be closed. So you could include code in the form's OnClose event to also record when it was closed.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Security (Access 2000)

    Mark suggested an excellent way of tracking who logged into the database and when, given that you activate Access security. Otherwise all you will get is Admin opened the database at such a time over and over again. If you haven't explored Access security, there's and excellent white paper that lays it out pretty clearly. In addition, you will probably want to track who entered records and when, and who edited them last. That is typically done by setting defaults for the fields on entered, and done with hidden controls that are set in code when a record is updated. If you really want to get down to the nitty gritty, we put the tables into SQL Server, and then use triggers to track every change and archive the record before it is updated. Hope this gives you some ideas.
    Wendell

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    Further to Wendell's and Mark's posts -
    If you are not using Access Security you could use the Windows API to retrieve a lot of the info that you might want.
    Take a look at Dev Ashish's site at:
    <A target="_blank" HREF=http://mvps.org/access/api/index.htm>http://mvps.org/access/api/index.htm</A>
    I use the User Name; OS Name and the Version of my DB to implement 'Big Brother' ! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    HTH
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  5. #5
    New Lounger
    Join Date
    Jan 2002
    Location
    Wales
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Access 2000)

    Thanks Steve - useful stuff I had'nt thought of tinkering with the API
    Regards
    Waring Thin

Posting Permissions

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