By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

tracking changes among records in ms access

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.