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???

Racecar wrote:
> 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.

--
Joseph Meehan

Dia duit

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

"Racecar" <(E-Mail Removed)> wrote in message
news:32B63B4E-BF17-4C90-93AD-(E-Mail Removed)...
> 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