I have an Access database with the ID field being the primary key.

I want to INSERT a new record into the database but if I don't enter ID field, I get an error "Primary key can't be null value". I understand why I get it but is there any way for Access to automatically generate a new value for ID when I INSERT a new record?

Otherwise, it seems I have to go through the database each time I want to INSERT a record and check for the highest ID value. Is this correct?

Thanks.

Howard

Access should automatically generate a new value for ID when a new record is inserted. My guess is there's something wrong with your insert statement (you shouldn't put the ID field in the field list). Show us your query!

Have you tried to set the Data type for the ID field to AutoNumber?

Regards

pgtips, will access automatically add a value if 'AutoNumber' has not been added? I was under the impression that you have to add autonumber for access to auto increment like Malu pointed out.

No it won't. I took it as read that the field was actually an autonumber field, but perhaps its not.

You were right, I didn't have it set as an autonumber.

Thanks.

HL