Audit Trail

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Debster
    #1

    Audit Trail

    I have been working with theexample that Allen Brown as provided,
    however I am receiving declaration problems coming from the primary
    keys found in the tables being audited. Any suggestions?
    Tags: None
    • Allen Browne
      #2
      Re: Audit Trail

      Hi Debster

      The primary key (autonumber) field in the table you are auditing must appear
      in both the temp table and also in the audit table. However, you need to use
      a Number field without a unique index in place of the AutoNumber field.

      Also, the order of the fields is important: you must have the same fields,
      in the same order, because the append query statements use wildcards.

      --
      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.

      "Debster" <albddtg@nmcour ts.com> wrote in message
      news:ea606150.0 405200953.375cb db8@posting.goo gle.com...[color=blue]
      > I have been working with theexample that Allen Browne as provided,
      > however I am receiving declaration problems coming from the primary
      > keys found in the tables being audited. Any suggestions?[/color]


        Comment

        Previous template Next
        Working...