AutoNumber field

R

Roger Bell

I have created an AutoNumber Field in a data base and
added several hundred records.
I want to use the same design for a seperate data base
and have made a copy of the original data base and
deleted all the records. My problem is that when I start
adding records to the new data base, it automatically
generates a new number eg: 306, and does not start with
1, which is what i want.

Any help would be appreciated
 
L

Larry Daugherty

Hi roger,

If you even care what an autonumber value is then you are miss-using it. It
should never be visible to your users and you shouldn't care what its value
might be. The autonumber datatype exists strictly to generate uniqueness
for use as a surrogate key.

All that being said, when you start with your new empty structure, compact
before you add any records.

HTH
 
Top