
no error when inserting duplicates into Access
Somehow, you're failing to trap the generated errors. Please post some of your
relevant code so that we can see where the oversight is.
-Curtis Spendlove
-Solstice Software
Quote:
>I am trying to get an error msg. when using VB to insert a duplicate record
> into an Access table. I have composite key fields defined in Access. If
>I try to enter a duplicate record manually in the Access table I get an
>error. If I try using VB to enter the duplicate record it just ignores the
>duplicate and doesn't give me an error msg. I'm using SQL stmts to import
>and sort a text file and then to insert the records into an Access DB.