Autonumbering Old Records

[Lambi000]

I have a database with a little over a hundred records that we just revamped.
My boss wants the new record ID to be an autonumber. The problem is that
the old ID had company identifiers (our location had no prefix but Location 2
had a 70 prefix making their numbers 7001, 7002, etc).

When I bring over the records into the new structure, my autonumbers start
at 7020, Location 2's last number, instead of 112, Location 1's last number.
Needless to say, we want to start at our Location number instead of theirs.
I tried cutting the 7000 series records and the autonumber starts at 112, but
when I paste in the 7000 series they renumber the ID's to 113 on.

Am I stuck with this situation and have to use a go-around, like a reference
field for their numbers? Or can I re-initialize the autonumbers to go to 112
and still keep the 7000 series values?

 

[Roger Carlson]

Yes, you can start Autonumbering with an initial value, but you really
should not be using autonumbers in the way you are attempting. You should
*never* care what the value of the autonumber is. If you do, you need to
create your own autonumber-like field. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"AutonumberProblem.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Lambi000]

OK, I'm off to try it. I'll get back to you with my success or lack thereof.