autonumber

hi
In a table, i've pasted 800 records in a file under field serial number and
have one cell with property "autonumber". The autonumber rises to value 800.

Again, when i delete all 800 records, and adds fresh ones, the "autonumber"
value starts from 801 onwards.

This makes the file size goes to as big as 45 MB.

Please suggest to optimize file and restart autonumber method.

thanks
deepak

After deleting the records Compact the database, this will reset all the
autonumber fields. If the data are held in a linked database you must
Compact the the database containing the actual tables not the linked.

"Deepak" wrote in message
...
hi
In a table, i've pasted 800 records in a file under field serial number
and
have one cell with property "autonumber". The autonumber rises to value
800.

Again, when i delete all 800 records, and adds fresh ones, the
"autonumber"
value starts from 801 onwards.

This makes the file size goes to as big as 45 MB.

Please suggest to optimize file and restart autonumber method.

thanks
deepak

Generaly, it isn't records who grow up the database. Jet works well for
this. It is when forms are modified frequently. Space are not reused by
access and compacting is needed

VD


"Deepak" a écrit dans le message de
...
hi
In a table, i've pasted 800 records in a file under field serial number
and
have one cell with property "autonumber". The autonumber rises to value
800.

Again, when i delete all 800 records, and adds fresh ones, the
"autonumber"
value starts from 801 onwards.

This makes the file size goes to as big as 45 MB.

Please suggest to optimize file and restart autonumber method.

thanks
deepak

Beware that even if you fix this AutoNumber now, the AutoNumber Field values
will develop gaps when Records are added / deleted (including cancelled
attempts to create new Records). These values can slso become random or
even negative, e.g. if you use replication.

Note that the only purpose of AutoNumber Field is to provide *uniqueness* to
each Record and the actually value allocated to each Record shouldn't
matter.

If you attach meaning to the values of AutoNumber Field, it may create
problems later.

--
HTH
Van T. Dinh
MVP (Access)


"Deepak" wrote in message
...
hi
In a table, i've pasted 800 records in a file under field serial number
and
have one cell with property "autonumber". The autonumber rises to value
800.

Again, when i delete all 800 records, and adds fresh ones, the
"autonumber"
value starts from 801 onwards.

This makes the file size goes to as big as 45 MB.

Please suggest to optimize file and restart autonumber method.

thanks
deepak