Mbak Morina Done, Beberapa link di bawah ini mungkin bisa membantu.
http://support.microsoft.com/kb/257408 ACC2000: AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database http://allenbrowne.com/ser-40.html Fixing AutoNumbers when Access assigns negatives or duplicates Prolog: In Access 2000 and later, an AutoNumber field may begin assigning extreme values, negatives, and even duplicates. The attempt to assign a duplicate fails if the field is primary key, so it may not be possible to save new records in an affected table. di link-nya Allen Browne juga disertakan function yang bagus. http://www.blueclaw-db.com/table_corrupted/repair_corrupted_database.htm Many of you have come across a table with #deleted or Chinese characters or square boxes in the fields of the table. Sometimes the problem will show up as an error message "The Search Key was not found in any record". You typically will not be able to delete the record nor modify it. It would be nice to know why this MS Access table corruption happens and how to fix it. We discuss both issues and provide a simple method to repair the corrupted database table. Salam Hangat dan Jabat Erat, Edy WIYONO ----- Original Message ----- From: Morina Done To: [email protected] Sent: Saturday, December 27, 2008 18:10 Subject: [belajar-access] How to Fix AutoNumber kacau & corrupted record Dear accesser, Nanya lagi ya .. mohon sharing pengalamannya 1.. Database saya autonumbernya tiba tiba ngaco. Misalnya sudah ada 4500 record, trus entah kenapa ketika sekarang add new record, auto number fielnya kok di serial 2000 an .. ? sudah saya compact ga berubah juga. Tetep begitu sehingga record ga bisa di save. Akhirnya, saya delete field nya dan ulang bikin field autonumber tsb. Dan ternayata 'sehat' kembali. Tapi saya penasaran, apa ada cara lain untuk fix autonumber ngaco tersebut, palagi compact udah ga mempan? 2.. Ada bbrp complain dari user, somehow record yang mereka simpan jadi corrupted dan berubah and tersimpan dalam bentuk Chinese character! Kira kira ini kenapa ya? memang recordnya sudah saya delete, karena ngerusak key, dan saya Cuma bilang ke user utk ulang bikin record tsb, dan berjalan baik. namun kejadian ini selama dua bulan ini udah kejadian 4 kali . ada ide ga kenapa bias corrupted record begitu yak? Thanksss . Morina
