My Autoexec macro does several things, among which it adds 1 to the number of users currently in the db (mysql backend file) and opens a hidden form and the main form. This main form displays the number of current users. Originally the close button on this main form subtracted 1 from the number of active users before closing the app. Some users were leaving the app by clicking the "X" rather than my big "Exit" button so that the number of current users was never decremented. Online suggestions were to open a hidden form and attach whatever I wanted to do in its onUnload. So now, I get the error msg "The data has been changed. Another user edited this record... " and it doesn't do the subtraction.
I can't figure out an order of events to make this work without throwing the error.
I can't figure out an order of events to make this work without throwing the error.