ID Autonumbers stopped at 104 and now lists as E+105. Why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on a small database. For some reason the Autonumbers stopped
increasing at 104 and from then on all new entrants were recorded as ID
E+105. Can anyone help me to sort this out so they read 105, 106. 107 and so
on?
 
Scotchbelle said:
I'm working on a small database. For some reason the Autonumbers stopped
increasing at 104 and from then on all new entrants were recorded as ID
E+105. Can anyone help me to sort this out so they read 105, 106. 107 and so
on?
Click to expand...

When Access uses the E+ notation it simply means the column is too narrow to
display the number normally.

Standard AutoNumber caveat: If you care about the value in ANY way other than
uniqueness, then don't use an AutoNumber. They will develop gaps and can on
occasion make large jumps or even go negative. Their ONLY purpose is to provide
a unique key for linking tables or to act as a surrogate Primary Key.
 
Back
Top