Index or primary key cannot contain a null value

  • Thread starter Thread starter FJB
  • Start date Start date
F

FJB

I have searched previous answers and do not find that fits my exact
situation.

I use a form linked to the table for input of data. There are multiple
users. This morning I did some work on the database:
-- exported the table to Excel so I could reverse the value of fields.
-- changed the data type on three fields from text to memo to allow for
additional verbage.

When I released the database back to the users, they are unable to save
data entered using the input form. I have tried several times and get
the same results.

Any thoughts?

Thanks, now, for your help.
 
Turns out this was my fault. When I reimported the data from Excel, I
told Access let me choose the primary key since they were a part of the
data I was importing. I reimported the data, dropped the key field and
let Access assign the key and everything is working fine.
 
Back
Top