Tracking Changes in Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nina - 13 Jul 2005 19:21 GMT

Can changes be tracked and/or highlighted automatically in Access 2000 (like
in Word and Excel)? If so, what is the procedure for doing this? Thanks in
advance.

Reply to this Message

Rick B - 13 Jul 2005 20:25 GMT

No, but you can build in the functionality.
Do a search and read the previous posts on "timestamp" and "audit trail".

Signature

Rick B

> Can changes be tracked and/or highlighted automatically in Access 2000 (like
> in Word and Excel)? If so, what is the procedure for doing this? Thanks in
> advance.

Reply to this Message

Jeff Boyce - 13 Jul 2005 21:26 GMT

Nina

Changes to data, or changes to structure/function?

Rick B. offers an approach to tracking changes to data, but Access does not
possess a logging function like SQL Server.

If you are tracking development changes to structure/function, consider a
configuration/change management tool. Visual Source Safe is one offered by
Microsoft.

Good luck

Jeff Boyce
<Access MVP>

> Can changes be tracked and/or highlighted automatically in Access 2000
> (like
> in Word and Excel)? If so, what is the procedure for doing this? Thanks in
> advance.

Reply to this Message