Access - Track Changes

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

 

[Tim Ferguson]

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

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

 

[Jessestonecedar]

start looking in the directon of the form property 'isdirty' and subjects
related to that.

 

[Jessestonecedar]

what's with the comment that access is not a real database. Ego here!

 

[Allen Browne]

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

 

[Tim Ferguson]

(e-mail address removed) (Jessestonecedar) wrote in

what's with the comment that access is not a real database. Ego here!

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