98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access duplicate error
Access duplicate error
Resolved · Low Priority · Version Standard
Ben has attended:
Access Introduction course
Access Intermediate course
Access duplicate error
When importing a table from excel I am trying to assign a particular field as the primary key. However access is telling me that I cannot assign it as a primary key and the following text comes up:
"The changes you requested 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."
This is the first table in the database, and having checked the list in excel I can see that there are no duplicates in existence in the column/field and yet the error comes up. The list is approximately 15000 records long. Would there be a reason why the error message comes up?
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Relationship mapsIt is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes |