autonumber

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
 
S

Steve

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.
 
V

vdavid

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
 
V

Van T. Dinh

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.
 

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

Top