Detecting changes to data in Access tables

[nazzaro]

Is there any way (other than designing additional tables/fields) to detect the last date/time data in an Access97 table was changed?<br><br>The MSysObjects table contains a &quot;LastUpdated&quot; field, but that applies only to the last time the table DESIGN was changed?<br><br>Am I stuck here, or is there some other &quot;hidden&quot; info that would allow me to do this?

 

[DougP]

here's a tidbit I ran across somewhere.<br>I don't know if it works, or if it will work in your situation either.<br><br>Private Sub Form_Open(Cancel As Integer)<br><br>&nbsp;&nbsp;&nbsp;&nbsp;LastUpdated = DLookup(&quot;DateUpdate&quot;, &quot;MSysObjects&quot;, &quot;Name = 'Table10' And Type = 1&quot<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>End Sub <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.