If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
autonumber
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 |
#3
|
|||
|
|||
autonumber
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 |
#4
|
|||
|
|||
autonumber
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 |
Thread Tools | |
Display Modes | |
|
|