I recently upgraded from Microsoft access 2003 to Microsoft access 2013 and when I did it messed up ALL of my file numbers. For instance my paper file may say its file number 48 but in access the file number has been changed to 50. I just want to find a way to fix that without having to reenter every little detail on every file. I have over 400 files and do not want to mess them up by trying to fix them.

---

Reply from Richard Rost:

What are these FILE NUMBERS you speak of? Are the Autonumbers? Access shouldn't change any of your data just from upgrading from one version to another. I've never seen this happen before. Now, if you're IMPORTING data from one database to another, that can happen. For example, if you create a new 2013 database and IMPORT your 2003 records, then yes, your Autonumbers will all change.