S
Say
Hi,
I am very new to & unfamiliar with Access. I am working with an already
existing database at my office.
Yesterday, my coworker exported a table into Excel to fix data in one
column. When she imported the table back to Access, we now get the error
message "Index or primary key cannot contain a Null value" message when we
try to input new data. Only one field is designated as the primary key and
it has data in it. And she erased all the indexes.
Last time she erased all the primary keys and reinputted them and this
solved the problem. However, this time that didn't work.
Sorry, this information might not be enough, but can anyone advise on what
the problem may be or how to fix it? My coworker is much more skilled with
Access but she hasn't been able to fix the problem.
Any help will be greatly appreciated!
I am very new to & unfamiliar with Access. I am working with an already
existing database at my office.
Yesterday, my coworker exported a table into Excel to fix data in one
column. When she imported the table back to Access, we now get the error
message "Index or primary key cannot contain a Null value" message when we
try to input new data. Only one field is designated as the primary key and
it has data in it. And she erased all the indexes.
Last time she erased all the primary keys and reinputted them and this
solved the problem. However, this time that didn't work.
Sorry, this information might not be enough, but can anyone advise on what
the problem may be or how to fix it? My coworker is much more skilled with
Access but she hasn't been able to fix the problem.
Any help will be greatly appreciated!