Alexander Willey
Registered User.
- Local time
- Today, 13:54
- Joined
- Mar 1, 2013
- Messages
- 31
Dear Forum
I am running an Access database that works like a timesheet system. It is split in to a front end and back end and the front end is used by about 15 users who each have a copy of the front end on their PC. The back end sits on the server. One of the users had an issue with their data entry form and after trying to compact and repair the back end, the issue appeared to be that one of the back end tables had lost its compound primary keys and had allowed duplication of an autonumber. I deleted the duplicate records, re-set the primary keys and joins and all appears OK, for now.
I would be grateful for any suggestions on how to prevent this issue occurring again.
Thank you in advance.
I am running an Access database that works like a timesheet system. It is split in to a front end and back end and the front end is used by about 15 users who each have a copy of the front end on their PC. The back end sits on the server. One of the users had an issue with their data entry form and after trying to compact and repair the back end, the issue appeared to be that one of the back end tables had lost its compound primary keys and had allowed duplication of an autonumber. I deleted the duplicate records, re-set the primary keys and joins and all appears OK, for now.
I would be grateful for any suggestions on how to prevent this issue occurring again.
Thank you in advance.