Does anyone know how I can change the autonumber value on a table when it has data in it - the last number is 9998 but the next one is coming up as 12924 and I want it to be 9999. Any ideas?