There are three users in an office I support who are entering data into an Access database. They are each using their own front end which is linked to the backend where the data resides. They have been using this same database for more than 5 years without any problem and now all of a sudden the autonumber field is duplicating numbers. I have tried compact and repair on the backend as well as on each person's front end and it is still continuing to happen. Could a virus cause something like this to happen?
What steps should I take to fix this database?