I have made a program in VB with Access as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when i enter an already existing id. matching all three fields and not allow duplicate entry.
there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.