Hi,
I have a table called addressbook.
it contains an email field.
I have that the user enter his list of emails into this table but if the email already exists the new records just be added?
what should i do?
that is my code


do while not rs4.eof
if rs2("email")<> strEmail then
sql = "INSERT INTO AddressBook(email,ID)"
sql= sql & " VALUES ('"
sql=sql & strEmail & "', '"
sql=sql & "1" & "');"
conn.execute(SQL)

rs4.moveNext
Loop
next

Create a Key based on username and email address. This constraint will be violated if a user enters an email address that already exists. You can then trap the error in your code and notify the user.