469,926 Members | 1,767 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

Duplicate autonumber

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
Nov 12 '05 #1
2 2327
"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.
Nov 12 '05 #2
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Charles Ledbetter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.