is is possible to set autonumber to start at 10000

  • Thread starter Thread starter accnewb
  • Start date Start date
A

accnewb

i would like to start the autonumber at a number greater than 1. Is this
possible?
 
a) using SQL Server; it is quite easy to do this
b) programmatically using ADOX I believe that you can do this with
Jet.

I just find SQL Server easier to use than Jet.. so I think that
setting the Identitiy and Seed and Increment Properties-- via the
GUI-- is a lot easier.

Thanks

-Aaron
 
There is a method described here:
http://allenbrowne.com/ser-26.html
However, if you want sequential numbering you should not use autonumber, as
it will almost certainly leave gaps in the numbering. If gaps are a
problem, what exactly do you need to do?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autonumber error 3
AutoNumber Minimum Value 3
Autonumber primary key 4
Autonumbering Query 1
Autonumber Macro 3
Add autonumber to a large table? 0
TINA - autonumber 2
Reset Autonumber 2

Back
Top