Visual Basic&database, converting database

converting database

Author	Message
Jame #1 / 3	converting database Hi I have just converted a access 2 database to a access 2000 database all went well but when I added a new record to the database the autonumber fields had changed.. The last autonumber was 13060 and after the conversion it went to 2781507. All number after this still increment by one but there is a massive gap. Any body got any idea's any help much appreciated James
Wed, 25 Jun 2003 10:26:04 GMT

Henning Forgaar #2 / 3	converting database Just delete the field in access and add it again as autonumber, then it will be reset back to the total number of records in the table. Quote: > Hi I have just converted a access 2 database to a access 2000 database all > went well but when I added a new record to the database the autonumber > fields had changed.. The last autonumber was 13060 and after the conversion > it went to 2781507. All number after this still increment by one but there > is a massive gap. > Any body got any idea's any help much appreciated > James
Wed, 25 Jun 2003 23:20:04 GMT

EScarff4 #3 / 3	converting database Delete the most recent records which are out of sequence. Then compact the database which contains the table in question. New records entered now should receive the next autonumber.
Thu, 26 Jun 2003 04:59:59 GMT

Page 1 of 1

[ 3 post ]