Access does not record this data, but you can do it if all updates are done
through forms.
Add a date/time field named (say) UpdatedOn to your table.
In the BeforeUpdate event procedure of the form:
Me.UpdatedOn = Now()
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nicholas Howells" <N G
Ho*****@ntlworld.com> wrote in message
news:t8***************@newsfe3-gui.ntli.net...
I have an access database and I often need to check when a record was last
changed by a user. Is there a simple way to achieve this