Auto numbers

  • Thread starter peljo via AccessMonster.com
  • Start date
P

peljo via AccessMonster.com

The auto numbers of my tables begin with 1000 and i have reached 1500. Which
is the best way to to preserve the old auto numbers and begin the numbering
with 2000?
 
K

Keith Wilby

peljo via AccessMonster.com said:
The auto numbers of my tables begin with 1000 and i have reached 1500.
Which
is the best way to to preserve the old auto numbers and begin the
numbering
with 2000?

AutoNumbers are for internal indexing purposes and should be hidden from the
user. If you want custom record numbering you'd have to code it yourself
using something like DMax.

Regards,
Keith.
www.keithwilby.com
 
Top