primary key (autoincrement) formatting errors

  • Thread starter Thread starter michael munson
  • Start date Start date
M

michael munson

I have a database of several thousand records.

Withot making any changes to the database, but in entering
new data today, the format of my primary key (which is an
auto-increment/number type of field) changed from
numbering records like 2023, 2024, 2025, etc. to
453053862, 453053863, 453053864, etc.

I use the ID number when I work with this data and NEED it
to be inline with what it had been.

Any ideas?

michael munson
(e-mail address removed)
 
michael munson said:
I have a database of several thousand records.

Withot making any changes to the database, but in entering
new data today, the format of my primary key (which is an
auto-increment/number type of field) changed from
numbering records like 2023, 2024, 2025, etc. to
453053862, 453053863, 453053864, etc.

I use the ID number when I work with this data and NEED it
to be inline with what it had been.
Click to expand...

Standard advice is that if you care about the value in any sense other than
uniqueness, the DON'T use an AutoNumber. If you do a search you will find
several alternative ways to automatically increment a number value when you
insert records. AutoNumber WILL develop gaps when used normally.
 
Back
Top