Index or primary key cannot contain Null value, Access
The error “Index or primary key cannot contain Null value“, occurs when you have left the primary key (index) field empty:
Every table in an Access database must have a primary key, and the primary key value for each record must be unique.
The reason you are getting this error is because there is record in the database where this field has been left empty. This error normally occurs when you have changed the default data type of the primary key (Index) from Autonumber to another data type. In order to solve this issue you will need to figure out the primary key (index) field, and fill it with a unique value.
Select the table that is generating this error and open it in design view:
The primary key (Index) field will have a key next to it.
After figuring out the primary key (index) field, remember not to leave it blank:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com
3 thoughts on “Index or primary key cannot contain Null value, Access”