|Well, first of all, why on earth are you using VB6, which is a dead language, and which always sucked ?
You need to write SQL that deletes your records properly, or refuses to delete them at all, if that's what you want. Simple as that, you know the problem, so write code that deals with it, in the manner you are looking for.
Please read this
if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )