Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access duplicate error

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access duplicate error

Access duplicate error

ResolvedVersion 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?

RE: Access duplicate error

Apologies. New to access and still feeling a bit lost when using it. There were duplicate records....

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.