Can I track and view changes in Access?

[Guest]

Like Track Changes in Excel, if it's possible, I need to find the changes
that were made in an Access 2003 DB: such as text changes, Record additions
or deletions and so on. Is this possible???

 

[Joseph Meehan]

Like Track Changes in Excel, if it's possible, I need to find the
changes that were made in an Access 2003 DB: such as text changes,
Record additions or deletions and so on. Is this possible???

I don't believe there is any direct method. There are several home
grown methods to track various changes.

 

[(PeteCresswell)]

Per Racecar:

Like Track Changes in Excel, if it's possible, I need to find the changes
that were made in an Access 2003 DB: such as text changes, Record additions
or deletions and so on. Is this possible???

Only if you code it yourself. It's too late after-the-fact unless you have two
versions of the same DB and do a field-by-field compare.

 

[Arvin Meyer [MVP]]

Like Track Changes in Excel, if it's possible, I need to find the changes
that were made in an Access 2003 DB: such as text changes, Record additions
or deletions and so on. Is this possible???

I write the changes to a history table in the form's BeforeUpdate event.
Something like:

strSQL = "INSERT INTO tblHistory ( Field1, Field2, ...)"
strSQL = strSQL & " VALUES (" & rst!ID & ", '" & strValue & "', " & ... &
"');"
db.Execute strSQL
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access