I have a database with the following setup.
Backend database with all sensitive data saved as .mdb
Frontend database with forms, reports and a few local tables saved as .mdb
I am adding a feature that when a button is clicked all the dates in a field called "DateSent" are changed to today's date. My question is, since multiple users are using the database would an update query work without corrupting data?
I had an old feature that updated data with a VBA Update query and it corrupted a record since I am pretty sure another user had that record open when the update query was run.
What is the safest way to update every records "Date Sent" field with multiple users using the database?
Thanks!