Auditing changes on unbound forms

[robert d via AccessMonster.com]

I need to implement some kind of auditing system for changes made to the
tables. My app uses DAO almost exclusively and all but maybe 3 or 4 forms
out of 100+ are unbound.

I'm not sure how to design this for my situations.

Suggestions are greatly appreciated.

 

[robert d via AccessMonster.com]

Actually, I should mention that the backend will be SQL Server and
unfortunately, I don't know very much about SQL Server, but have been able to
get my app to successfully link to tables in SQL Server (with much faster
response than the Jet backend on a server).

 

[Duane Hookom]

I would create a trigger on the table to record this. You might want to ask
in a SQL server news group and/or search google.