Results 1 to 2 of 2
  1. #1
    neil45156 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2011
    Posts
    4

    Tracking Data

    Hi Everyone,
    Does anyone know if there is a way that if user1 signs in and adds data to the database, then user2 signs in and adds data, can I track who has added what to the database?

    I am using Access 2003.

    Thanks

    Neil45156

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    That is called an Audit trail. Sometimes it is refered to as maintaining a history of changes.

    Here is three examples to look at:

    Rogers Access Library:

    AuditTrail.mdb ( intermediate )
    http://www.rogersaccesslibrary.com/forum/topic399.html

    AuditTrail2.mdb ( advanced )
    http://www.rogersaccesslibrary.com/forum/topic398.html


    The Access Web:


    Maintain a history of changes
    http://www.mvps.org/access/modules/mdl0021.htm

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

Similar Threads

  1. Demographic Tracking
    By leetx in forum Database Design
    Replies: 3
    Last Post: 12-02-2010, 02:49 PM
  2. Employee Tracking
    By nycon in forum Access
    Replies: 6
    Last Post: 10-27-2010, 05:42 PM
  3. login tracking
    By itsmemike in forum Access
    Replies: 8
    Last Post: 09-18-2010, 08:05 AM
  4. Tracking End of Month Data
    By spherearrow in forum Database Design
    Replies: 5
    Last Post: 09-13-2010, 10:55 AM
  5. tracking
    By mugziegumz in forum Access
    Replies: 0
    Last Post: 11-20-2008, 10:11 AM

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