To initialise long integer autoincriment datatype into 0

[pol]

It would be very helpful to me if you can give me the solution for initialise
into 0 autoincriment column in a table. I am using access2007.

Also please let me know the size of the data can be hold in autoincriment
long integer column

with thanks
pol

 

[Jeff Boyce]

Check Access HELP for "specification" to learn the size of the long int
values Access places in an Autonumber column.

Why do you care what value appears in the autonumber field? Access
Autonumbers are intended to be used as unique row identifiers. They are not
guaranteed to be sequential, and are generally unfit for human consumption.

What are you trying to accomplish by having an autonumber field get
re-initialized to 0?

Regards

Jeff Boyce
Microsoft Office/Access MVP