Access - Track Changes

  • Thread starter Thread starter Don M
  • Start date Start date
D

Don M

Is there or does any one know if it exists to be able to
track changes of data being changed or inputed into a
simple access database created all by wizzards. Similar
to that of Excel>tools>track changes. I have looked to
great effort, but only items of tracking design changes.
 
Is there or does any one know if it exists to be able to
track changes of data being changed or inputed into a
simple access database
Click to expand...

To a large extent it depends what you mean by a "simple" access database.
In short, you can only track changes that are made by a form, and then
you'll need to program them yourself. For some people this is simple, for
others, not.

If you want a bullet-proof audit trail that works regardless of the source
of changes, then you need to move up to a real RDBMS like SQL Server, msde,
etc, etc.

Hope that helps


Tim F
 
start looking in the directon of the form property 'isdirty' and subjects
related to that.
 
Access does not provide a way to track changes to the data.

If all changes are made through forms, you can use the events of the form to
roll your own, but you will need a good understanding of how the events work
and be comfortable with VBA code to achieve that.

For details on how to log inserts, deletes, and edits, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
 
(e-mail address removed) (Jessestonecedar) wrote in
what's with the comment that access is not a real database. Ego here!
Click to expand...

Check out how many of Codd's rules it satsifies... and don't forget the
implicit rule zero, which it also does not satisfy.

B Wishes


Tim F
 
Back
Top