"duplicate values in the index, primary key, or relationship" Error. Help needed
I have a split Access 2007 database with the backend on a shared drive and copies of the frontend distributed to users. It worked perfectly when I tested it on my computer, even testing multiple copies at once. But when multiple users on different computers attempt to enter records at the same time, the second person to finish entering their record gets the message: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." When I look at the backend tables after this, the first record is entered fine and the following row just says error.
I have a form in data entry mode that has the fields of Table A. This form has a subform with the fields of Table B. Table A's autonumber ID field is a foreign key in Table B. The autonumber fields are of course not added by the users.
I'm really stuck here and could use some help.
Thanks
I have a split Access 2007 database with the backend on a shared drive and copies of the frontend distributed to users. It worked perfectly when I tested it on my computer, even testing multiple copies at once. But when multiple users on different computers attempt to enter records at the same time, the second person to finish entering their record gets the message: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." When I look at the backend tables after this, the first record is entered fine and the following row just says error.
I have a form in data entry mode that has the fields of Table A. This form has a subform with the fields of Table B. Table A's autonumber ID field is a foreign key in Table B. The autonumber fields are of course not added by the users.
I'm really stuck here and could use some help.
Thanks