Re: Database Out Of Sync

dono how your setup exactly looks; however if you have constraints on them to garantee uniquenes or?? you may want to look at a thing called violations tables and have your constraints set to filterring without error. check the manual for it do not have the syntax at hand sorry. it boils down to tab1( col1int, col2 char) has pk on col1 and has say 2 records in it say 1,"one" 2,"two" when you reinsert 1,"one" it does not end up in tab1 but in it's violation table. so if you want to get rid of the unwanted you can get rid of the violation table stop violations and set your constraints to be 'normal' again. you also can use dbload and set the # of errors big i guess. Superboer.