eggwater
life as a rehearsal
- Local time
- Today, 21:20
- Joined
- Aug 14, 2003
- Messages
- 69
I have a number of users using a database. They input data using a form. The database is split into Front End, Back End and i'm pretty sure that the record locks are set correctly and the users should not be able to delete records unless it was by accident evn so it would have to follow a number of coincidences for a record to get deleted.
Is it possible that new records could not be saved or that old records could go missing.
It would therefore appear that out of about 1000 records 10 or so have gone missing.
I am of the assumption tht this is some kind of user error , but the users are swearing blind that they entered the data. They actually write down the autonumber ID on top of the forms they are entering data from.
has anyone had a similar problem or is there anything that could cause this to happen?
Is it possible that new records could not be saved or that old records could go missing.
It would therefore appear that out of about 1000 records 10 or so have gone missing.
I am of the assumption tht this is some kind of user error , but the users are swearing blind that they entered the data. They actually write down the autonumber ID on top of the forms they are entering data from.
has anyone had a similar problem or is there anything that could cause this to happen?