I am creating an application using an Access databse and ADO. In one of my table, I need to create a unique record number. I need it to stay up-to-date of course when doing inserts, but also when deleting records.

Does anyone have ideas, tips, examples of how this is done ?

Thanks !