Auto numbering

L

Laurena

Auto numbering starts at 1 but I want it to start at
11890. How do I change the auto numbering format????
 
C

cTaHk0

in Access help see topic "Change the starting value of an incrementing
AutoNumber field"

regards,
CTaHk0
 
A

Allen Browne

The simplest approach is to import a record containing the value 11889.
Details:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

In Access 2000 and later, it is also possible to set the Seed of the
Autonumber field. Use the ADOX library to set the "Seed" property of the
Column in the Table in the Catalog.
 
Top