To initialise long integer autoincriment datatype into 0



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



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?


Jeff Boyce
Microsoft Office/Access MVP

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