To initialise long integer autoincriment datatype into 0

P

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
 
J

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
 

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

Very urgent for autoincriment primary key 17
to make datatype as decimal or double for temprary column 4
Trying to add Long Integer field 1
Datatype Mismatch using integer 2
bitwise operator in SQL 3
Data Mismatch in Excel 2010 4
to give if condition in MS Access 2
To give sql by removing empty space from the data 3

Top