won't set primary key-error 3022

G

g noseworthy

Playing with a small table, and trying to set a single
field primary key, but get an error stating that there are
already duplicate values. I have deleted any
relationships to that table, removed all indexes and
visually checked that field for duplicate values but there
are none...am i missing something?
 
G

gillian

-----Original Message-----
Gilian,
Have you looked for records with blank or null key values?
Bruce

.
Hi Bruce,
Click to expand...
the primary key i'm trying to designate is a natural key
and an essential part of the record, there cannot be any
nulls or blanks in that field (duplicates are common
errors in data entry though). There are only 150 records
in this table, so i should have spotted blanks. This
table has been imported from DBIII, could that have
something to do with it?
Gill
 

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

Can't assign primary key 3
Error 3022 0
import data from excel 2003 to a table in an existing database 2
Do I have to set the primary key to include primary key fields? 3
Replace Error 3022 VBA with specific field labels 0
Duplicate values in the index, primary key, or relationship messag 2
Duplicate Values in the index, primary key or relationship 4
primary key - concatenated or autonumber? 6

Top