I'm attempting to insert new records into the database. The ID fields are all full of some long ID number. Can you provide a reference to where this ID number comes from and if it's safe to just insert a unique number into this field?
It can be anything as long as it's unique. I believe Access has a Rnd() function that could be utilized.