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.
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?
