I have a table with a missing record, when I recreate it (18) the new id is 127 because it's
autoincrement. When I go to change the row id to 18 (and there is obviously no row with the id 18) it doesn't allow me to change it.
I've attempted to export the data as XML, change the id to 18 and import/append data however that doesn't seem to do anything.
So how do I force Access to recreate the table row 18 when I have over a hundred rows?