Jürgen Welz
jwelz at hotmail.com
Tue Feb 7 15:54:13 CST 2006
Trouble call from users: Enter a name in search combo and a record from 3 years ago with a different name shows up. Have a look at the table. I have 30 records duplicating the Autonumber PK. She's gone back a bit over 3 years. AN was at 17,000 and is now duplicating rows from 7474 after a corrupt record with AN 2759985. Corrupt record has text with characters I've never seen before and several foreign keys showing 7474 and one showing 1677749760 (normal range of values from 0 through 3). Several of these duplicate records are subsequent to our last compact/repair. Now I must fix the records and divide the child records between the proper parents. Good thing there are lots of backups so I can match the related records to the original parents. What a waste of time. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com