Access 2003 on XP
Someone here at work deleted a record (&$%^&*&!!!) and screwed up the Autonumber "Job ID" field . I need to reset the Autonumber field back to it's original numbers and still keep all the data in the table assigned to the correct Job ID (1-155).
I copied everything from the table to Excel for safekeeping. I deleted the Autonumber field and went through the steps (http://support.microsoft.com/kb/812718 ) but when I reinsert the Autonumber Job ID field, it reorders everything and the wrong number gets assigned.
I tried again by importing from the Excel file into a new Access table but the reports, queries and forms all have huge association errors. It won't let me "copy" the data from Excel into the old Access table.
What do I do?
Thanks, Marjo