tracking changes among records in ms access

[ken]

Hi,
I have a database that spits out reports. It takes a while for the
report to be ready and many people contribute. I need to keep track of
what changes are made. It would be nice to keep track of every change
to every cell. I never did this before and the only way I can think of
doing it is if in a certain record a certain change was made, just copy
that record and label the changed field. But I just thought I'd ask if
anyone else has experience in this. Maybe there is a better way. All
changed can be flushed once a report is approved so they don't
neccesarely have to stay in the database.

Thanks

[Allen Browne]

Access does not provide logging, and does not have triggers at the engine
level.

However, if all inserts, deletes, and edits are performed through forms, you
can use the events of the form to log the information.

Detailed example:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

You will need to have an understanding of the events of the form and be
comfortable with VBA to use this.

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

"ken" <ge****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hi,
I have a database that spits out reports. It takes a while for the
report to be ready and many people contribute. I need to keep track of
what changes are made. It would be nice to keep track of every change
to every cell. I never did this before and the only way I can think of
doing it is if in a certain record a certain change was made, just copy
that record and label the changed field. But I just thought I'd ask if
anyone else has experience in this. Maybe there is a better way. All
changed can be flushed once a report is approved so they don't
neccesarely have to stay in the database.

Thanks