By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

Duplicate autonumber

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.