Results 1 to 7 of 7
  1. #1
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159

    Log time and date users update records


    Hello everybody,

    I am looking for a bit of advice. I want to store the time and user who updates a table. tm_update, user_id stored in each table.

    Any advice on the best approach would be super.

    Thanks,
    Rich

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Are you looking to log this information on a backend database? or built into the same mdb the user is on.

  3. #3
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159
    Build it into the same one.

  4. #4
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    I hope this helps, http://allenbrowne.com/AppAudit.html I tried using this, but I needed a back end scenario. Either way, AllenBrowne is a genius.

    And if you want to track form usage, http://allenbrowne.com/AppLogDocUse.html

    I was able to modify the last one to do an update query whenever a user clicks a command button on the form.. It updates the back end. I can see who is signed in, and what button they clicked at what time. I could have pulled a lot more information but thats all I needed.
    Last edited by redbull; 06-13-2012 at 08:05 AM. Reason: update

  5. #5
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159
    Hey thanks. I will have a gawk and let you know.

    Just been dragged back into a db I thought was finished! Ahhhhhhhhhh,............ it never ends!

  6. #6
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Like trying to find a Corner in a round room.

  7. #7
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I am a longtime Access programmer who just joined this forum yesterday (I am active in other forums). I was checking out some information on this site, and came across this thread in the Code Repository, which looks like it might also have what you are looking for: https://www.accessforums.net/code-re...rds-10212.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-02-2012, 06:06 AM
  2. Replies: 2
    Last Post: 11-14-2011, 09:16 AM
  3. How many users at the same time?
    By raffie77 in forum Access
    Replies: 1
    Last Post: 08-21-2011, 09:05 AM
  4. Replies: 7
    Last Post: 05-31-2011, 11:51 AM
  5. Multiple users in database at same time
    By toshea in forum Security
    Replies: 4
    Last Post: 12-07-2009, 02:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums