duplicate insertion error

Results 1 to 2 of 2

Thread: duplicate insertion error

  1. #1
    Join Date
    Dec 1969

    Default duplicate insertion error

    I talking with a friend about ways to prevent duplicate record insertion in an Access db we discovered that we use the same method but in different ways.<BR><BR>He uses if Err.Number = -2147217887 then<BR><BR>and I use if Err.Number = -2147217900 then<BR><BR>Both work but I&#039;m curious as to why. Can&#039;t find it in the docs so I wonder if anyone may know.

  2. #2
    Join Date
    Dec 1969

    Default RE: duplicate insertion error

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adoce31/html/ado30ref_103.asp<BR><BR>-2147217887 is hex 80040E21<BR><BR>-2147217900 is hex 80040E14<BR><BR>Looking at the descriptions of those two, I can&#039;t figure out why either one works.<BR><BR>If you don&#039;t trap the error, what is the message you get in each case?<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts