Welcome to SPN

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

Sign Up Now!

Track changes

Discussion in 'Information Technology' started by JK, Jul 28, 2006.

Tags:
  1. JK

    JK
    Expand Collapse
    Guest

    What's the best way to track changes made to records in an Access 2003
    database? I want to track changes (updates, edits, deletions) to a subform
    that points to an equipment table. Ideally I'd use the persons network logon
    (active directory username) to stamp who did it, along with the date and
    time.

    Thanks!
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Do a search and read the previous posts on the topic. Look for "timestamps"
    or "audit trail". That should get you lots of good posts with examples.

    --
    Rick B



    "JK" <noneya> wrote in message news:epqvgsreGHA.4948@TK2MSFTNGP04.phx.gbl...
    > What's the best way to track changes made to records in an Access 2003
    > database? I want to track changes (updates, edits, deletions) to a subform
    > that points to an equipment table. Ideally I'd use the persons network
    > logon (active directory username) to stamp who did it, along with the date
    > and time.
    >
    > Thanks!
    >
     
  4. JK

    JK
    Expand Collapse
    Guest

    I found a good one for the audit trail.
    http://support.microsoft.com/kb/q183792/


    Now all I need is the username integration. I'm not using (nor do I need to)
    access security. I want to log the users windows logon name. Any ideas?

    Thanks!


    "Rick B" <Anonymous> wrote in message
    news:%23EJdVvreGHA.1324@TK2MSFTNGP04.phx.gbl...
    > Do a search and read the previous posts on the topic. Look for
    > "timestamps" or "audit trail". That should get you lots of good posts
    > with examples.


    > "JK" <noneya> wrote in message
    > news:epqvgsreGHA.4948@TK2MSFTNGP04.phx.gbl...
    >> What's the best way to track changes made to records in an Access 2003
    >> database? I want to track changes (updates, edits, deletions) to a
    >> subform that points to an equipment table. Ideally I'd use the persons
    >> network logon (active directory username) to stamp who did it, along with
    >> the date and time.
     
  5. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can get the Windows user name from this API call:
    http://www.mvps.org/access/api/api0008.htm

    The kb article you found is good if you only want to log changes to fields.
    It does not log deletions. For an alternative, see:
    Audit Trail - Log changes at the record level
    at:
    http://allenbrowne.com/AppAudit.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "JK" <noneya> wrote in message news:OaxUgNseGHA.3484@TK2MSFTNGP02.phx.gbl...
    >I found a good one for the audit trail.
    >http://support.microsoft.com/kb/q183792/
    >
    >
    > Now all I need is the username integration. I'm not using (nor do I need
    > to) access security. I want to log the users windows logon name. Any
    > ideas?
    >
    > Thanks!
    >
    >
    > "Rick B" <Anonymous> wrote in message
    > news:%23EJdVvreGHA.1324@TK2MSFTNGP04.phx.gbl...
    >> Do a search and read the previous posts on the topic. Look for
    >> "timestamps" or "audit trail". That should get you lots of good posts
    >> with examples.

    >
    >> "JK" <noneya> wrote in message
    >> news:epqvgsreGHA.4948@TK2MSFTNGP04.phx.gbl...
    >>> What's the best way to track changes made to records in an Access 2003
    >>> database? I want to track changes (updates, edits, deletions) to a
    >>> subform that points to an equipment table. Ideally I'd use the persons
    >>> network logon (active directory username) to stamp who did it, along
    >>> with the date and time.
     

Share This Page