Do delete queries stop an autonumber from running correctly?
I ask this because i have a autonumber that starts of a whatever number i like say 100 and when i ran it went 101, 102 and so on.
But when on the table i deleted the records the autonumber went back to 0.
I ask this because i have a autonumber that starts of a whatever number i like say 100 and when i ran it went 101, 102 and so on.
But when on the table i deleted the records the autonumber went back to 0.