As this is a rather old thread, are you working in the same situation as the original poster? That is, are you working with ODBC linked tables in an Access front-end? Or are you working with an Access ADP that connects directly to SQL Server? Also the versions may be important. In the first case, you can create VBA procedures that are initiated by the OnChange event of the form that update a last changed field, assuming that your form is bound to a table source. However if you allow editing at the table level, and at least some users will probably have that capability, then using triggers is the only effective way we have found to track who and when a record was last changed.