Ramoncito Medina (11/22/2007)
I enforce the "no duplicates" via my vb program and it is working.It's not joined, the data are directly inserted in the table from a text file via my vb program.
I'm wondering what miraculous chain of events allows vb program to enforce "no duplicates" when vb program is not looking at the target table... is it silent knowledge?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.