Hi I have come up with a strange error I have a table where one of the fields has a autonumber on it, and everything has worked fine for ages.
However the last number it succefully apply was 11429, then for no apperent reason it's now trying to use 10428!! Which is failing over due to dupilcate records.
Is their anyway I can manually set the autonumber, or does anyone else know of any way round this problem.
The easiest way to renumber an autonumber column in Access is, in the Design mode, delete the column(actually a row in the Design view) containing the autonumber (to do this you must first remove the Key designation if any - which is most likely). Save the database. Then Insert a new column (called Row in the design view) and redisignate it as Autonumber and Key (if necessary).
Provided there are records in the table (most likely) the above will work perfectly, but if you have used the autonumbers as an identity reference, make sure the table is sorted by the autonumber fields BEFORE you carry out the above. Also check to see if your last entry carries the correct autonumber for identity purposes.
If you simply enter a blank record and manually update the autonumber, you may be storing up problems for the future.