Primary key cannot contain a null value.

C

Chris

When copying one field in a database to another field, I
get the error "Primary key cannot contain a null value."
I currently have it set to "Yes, not allow duplicates." I
couldn't find the solution on the MS Knowledge base.
 
M

Michael J. Strickland

In design view, select the field that is designated primary key and click
the Key icon (clear its primary key status).
 

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

primary key - concatenated or autonumber? 6
Primary Key - Null Value 4
Duplicate values 4
primary key 3
Index or Primary Key Cannot Contain a Null Value 1
when using two primary keys in a Access 2003 table I get an error. 2
Duplicate values in the index, primary key, or relationship messag 2
How do I find the indices on a table in Access 2003? 4

Top