So, this Access file I refactored last year... two months ago some user called me because a few records were missing. I was pretty nervous because I thought I had fucked something up. User aren't supposed to delete any records, and I doubted any of them had the skills to find out how they could do it.
I couldn't find any errors. The records were in the last backup, but now they were gone. Shit.
I got another call last week - again, some record were missing. Maybe this was no error but someone overwrote the record IDs? They contain country information about the records (not my design). So maybe someone assigned the records to another country and also changed the IDs?
I tried to find similar records. For each record, there's a field with the username who last modified it. I called all of them and asked if they modified country data or noticed any warnings or errors.
Nothing.
Then I found another trace leading me to the user who actually notified me about the missing data. She's one of the main users and has been working with the file since a long time, so no way she could have overlooked a problem. Nevertheless, I send my standard "did you notice anything" email, and she offered to start a screensharing session to show me how she's working with the file.
I didn't expect this to help me in any way, but I agreed.
Before I conclude, I need to explain the interface: It's a simple master-detail view. The top half of the window is the list of records, the bottom half is a form showing the details of the selected record. They're separated by a toolbar with some buttons to add records, to save/undo changes in the detail form and a few more.
So, the user opened the file, wanted to add a new record.. and did not click the prominent "Add new record" button, but started editing in the detail view right away. When the file is opened, of course the first record is selected. She changed the data, including the ID, and saved it. I was speechless.
Fucking hell. Motherfucking hell. She never knew about the "Add" button. For more than a year, she had been overwriting existing records instead of adding new ones. To think about how much data is gone.. wow.
Overlooking the button, yeah, I could understand that, maybe. But what the fuck was she thinking when the text fields were already filled with data and she simply deleted the content or overwrote it?? Some people...