See:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html
You can also set the Seed of the Autoincrement column using ADOX if you use
a JET 4 database format.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Materialised" <ma**********@privacy.net> wrote in message
news:3v*************@individual.net...
I am writing a program in C, which will be driving via a MS Access
database.
I am relitivly new to database design, so if anyone could help me with my
issue I would be greatful.
I have defined a database field to be a primary Key, this field is set to
contain the AutoNumber data type.
I would like to know if it is possible to start the autonumber sequence
from a number other than 0.