Again Backup...

Make a copy of your table - Structure Only. (No data) and add new Auto number ID field.
Now create an append query and append all of the data into your new table from your old table.
You'll have a new ID and your old but all  your data will be there
.

Awesome!

Thank you that will be my next big task, and now I have some steps to follow.
I need to work on making append query, I have avoided append query for years, and I know there are plenty of videos from Richard, and my expert class to finish.

Honestly, (haha) I feel append query is like black magic / witchcraft, scary and I do not understand it, or how to fix something that goes sideways from a append query. I have done things differently and it's a manual (slow) way, and I know there are better ways to do things.

Append queries aren't difficult. Play with them in a COPY of your database. I have an old tutorial on them here. I also cover them in depth in Access Expert 14, which I see you have. I've got a TechHelp video coming up on them soon too. Search for "Append" in the site search box and you'll see there are a few other videos I cover them in too. Lots of resources.

Jon
Thanks by the way for your "vote of thanks".  I received the email.

The first time is always the hardest.  Just go step by step and you will get there.  if (when) you run into issues just holler.
I know I sound like a broken record,  but probably the best advice I can give you is back up.  Daily AND prior to making any potentially dangerous changes. Beat it into your own head.

Another thing that I recommend, when doing something new, is to work on a copy first.  It's easier to delete a copy and start over than to recover a live database.  Once you are confident that what you are doing is the right thing, then make the change to your real db.