Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page