Is there a way to store the timestamp in access?

advertisements

I want to create a table with timestamp field in Microsoft Access 2013, but there are not timestamp or rowverion datatype. How do I do this? Is there a way to store timestamp in access?


Based on your last comment, you need two fields: LastEdited (Date/Time with default = Now()) and TimesEdited (long integer with default = 0). LastEdited = Now() TimesEdited = TimesEdited + 1 Since you are using Access 2013, you can set a data macro to update both whenever the record is edited.