Auditing changes on unbound forms

  • Thread starter Thread starter robert d via AccessMonster.com
  • Start date Start date
R

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.
 
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).
 
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.
 
Back
Top