Error on form

D

Dick

My business has an Access database used by several
people. Both the front end and back end (actual data
tables) are on our network.
We've started getting an error (when someone tries to
enter a new record) that the change can't be accepted
because it would create duplicates in the index, primary
key or relationship.
Any ideas
(I'll admit to being a novice at this}.

Thanks
Dick
 
S

Shaun Beane

Dick said:
My business has an Access database used by several
people. Both the front end and back end (actual data
tables) are on our network.
We've started getting an error (when someone tries to
enter a new record) that the change can't be accepted
because it would create duplicates in the index, primary
key or relationship.
Any ideas
(I'll admit to being a novice at this}.

Thanks
Dick
Click to expand...
Do you know what the primary key is on this form and if it is an
autonumber or is being entered by the user?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After creating a Form, how do you you put four tables that have a. 2
Duplicate Subform and SubSubForm Records but not Main 1
subform still not working..... 0
Duplicate values in the index, primary key, or relationship messag 2
duplicate value error message - new issue 1
Duplicate Values in the index, primary key or relationship 4
Form refuses to open 1
Form Field Autofill from Table of Information 4

Top