AutoNumber

  • Thread starter Thread starter AMF
  • Start date Start date
A

AMF

I just began creating a database and am trying to set the
AutoNumber to somthing other than 1. I don't have any
records yet so I am assuming this should be pretty easy.
Online Help was not any help at all.

Thanks for your help.
 
You can do it by appending a record with the value you want. But if you
care what the number is, you shouldn't use an Autonumber field. Autonumbers
are only guaranteed to be unique, not sequential.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
This is a typical example of using AN for a wrong purpose. Next question
you will have will be "My AN PK has gaps in it and I want it to be sequential".
If you need a meaningful AN, make it yourself. Or better yet, do not put
any meaning to an autonumber field.

Pavel
 
Back
Top