Index or Primary Key Cannot Contain a Null Value

  • Thread starter Thread starter Gregc.
  • Start date Start date
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
 
Back
Top