Index or Primary Key Cannot Contain a Null Value

G

Gregc.

G'day

I imported a spreadsheet into Access to create a table. I want to make
the Field Name "ItemID" the primary key, with a Data Type "Number".
Each Number begins with a 0.

When I try to save it it comes up with "Index or Primary Key Cannot
Contain a Null Value". Is this because each number begins with 0, and
if so is there a way around it.

Greg
 

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

Index/Primary Key Error Handler 1
Primary Key - Null Value 4
primary key - concatenated or autonumber? 6
change numeric value in primary key 2
primary key 3
Primary Key Index 2
Duplicate Values in the index, primary key or relationship 3
when using two primary keys in a Access 2003 table I get an error. 2

Top