Duplicate autonumber

[C L Humphreys]

Hi,

I seem to have amassed a few thousand duplicates in an autonumber field. Is
there a simple way of updating these to new numbers?

Not sure if this is related - but I'm having problems searching for
duplicates, with the error "invalid argument" popping up.

Cheers,
Chris

[Fletcher Arnold]

"C L Humphreys" <cl*********@toofgib.moc> wrote in message
news:bm**********@ucsnew1.ncl.ac.uk...

Hi,

I seem to have amassed a few thousand duplicates in an autonumber field. Is there a simple way of updating these to new numbers?

Not sure if this is related - but I'm having problems searching for
duplicates, with the error "invalid argument" popping up.

Cheers,
Chris

Assuming that you have not placed any signifigance on the autonumbers and
are happy for them to be re-allocated with new numbers, I would do the
following:
Create a new empty table (possibly copy and paste structure only), then
create a query based on the old table. Run the query and copy and paste
append into the new table. This will recreate new autonumbers - hopefully
with no duplicates.

It might be an idea to then create a new database and import all the tables
from the old into the new, then do a compact and repair.

[Spartan117]

Just delete the autonumber field in the design view of the table.

Save it close, etc.

Then re-open it in design view, make the autonumber field again, and you
will have new numbers starting from 1, with no duplicates.

--
Spartan117
.... Humanities Last Hope