After importing all my data into Access, I decided I would like to add autonumbering. However, based on what I've read, this cannot be done after data has been netered into the database. Is there a workaround? Like importing the data into another new database or something?

Also if I am reading correctly, I will not be able to use my current numbering pattern (yyyy-count)since it contains a hyphen. Is this correct?

Any help would be greatly appreciated.