Automatic Timestamping

[BNPMike]

For web applications I'm thinking of using timestamps to control simultaneous updates. Your application retrieves rows and their timestamps, and when it tries to make an update it first checks the row timestamps are not now later, as that would indicate someone else has updated the row in the meantime.

However I've just carried out a test, and timestamps are not automatically updated. If you don't provide one on INSERT it will remain null.

Is there any way to get Jet to automatically timestamp records? Leaving it to the application is less safe.

 

[dhookom]

You can set a default on a date/time field of the current date and/or time. There are no triggers that can be set to automatically track last udpated. You would need to write this value in your web app.

Duane
Hook'D on Access
MS Access MVP