autonumber

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

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.
 
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
 
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.
 
Back
Top