log history of Access record changes,updated through a FrontPage A

[MickB]

I use FrontPage ASP update page to update individual records in an Access
database table, ok so far. As the ASP is multiuser, I wish to create a log of
changes to a record identifying what changed and who made the change.
I have looked through Allen Browne's suggestion, and if Im reading this
correctly, works for data changes to the Access table through Forms. Is
there someting I can use for updates through ASP update queries please

 

[S.Clark]

When a change occur, use an append query to write a record to the transaction
log table.

 

[Larry Linson]

I use FrontPage ASP update page to update individual
records in an Access database table, ok so far. As the
ASP is multiuser, I wish to create a log of changes to a
record identifying what changed and who made the change.
I have looked through Allen Browne's suggestion, and if
Im reading this correctly, works for data changes to the
Access table through Forms. Is there someting I can use
for updates through ASP update queries please.

You will have to determine how to identify the user making the update using
ActiveX Server Pages, .asp -- that is beyond the scope of this newsgroup.
FWIW, Access is not involved in what you are doing... what people call an
"Access database" used with Front Page is a Jet database. The Jet database
engine is the default database engine for Access 2003 and earlier, and
optional for Access 2007, but is a separate entity which is also used in
..asp. You can, as has been suggested, use a query to write a log, or if you
are only adding, not modifying existing records, you could add fields for
userid and date/time of the action.

Larry Linson
Microsoft Office Access MVP