Insert ignore

[isumasama]

hi how to do insert ignore in access? is access support this function?

CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")"

or how can i do a search for duplicate record first before insert?

thanks

[isumasama]

after trying too many times yesterday, i dont think MS Access support INSERT IGNORE.
what i did instead is:
1. get the count for the particular record.. if there's record then >0
2. use the if statement before inserting any record.

dim temp as string

'1.
temp = DCount("ID", "FullDB", "IDProc = " & IDProct & "AND IDOp = " & IDOpt & "AND IDTech = " & IDTecht & "")

'2.
If temp = 0 Then
    CurrentDb.Execute "INSERT INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")"
   
ElseIf temp > 0 Then

MsgBox "The record you try to add is already exists. Please refill the form.", vbExclamation

End If