Disappearing Records

[Fizzio]

I have something that is baffling me. I seem to have records disappearing from my Multi user Db (FE local, BE server). All data is inputted via forms with Allow Deletions set to No but records are just vanishing without trace. I have no delete queries, no VB code to delete anything but still they go. I am clutching at straws a bit now. most of the inputting is done on an A2k machine but the other users all use A97 (which is a headache in itself). Any other ideas? (other than sabotage which I have also considered)

 

[mbentley]

This is a long shot, but users sometimes overwrite old records with new info instead of clicking the new record button. Sounds crazy, but they do it all the time. If you have an autonumber ID field for your records, you may want to track them to see if this is the case. Just a thought...

 

[Fizzio]

I'd thought about that too but gave my users the benefit of the doubt. Maybe I should be less generous and treat all users as drones with no common sense but despite how much you limit their capabilities, they always manage to do something to your work!

Cheers

 

[mbentley]

Yep. They always manage to surprize you.