I have the unique field in my table in a access database<BR>"VisitID" how can I create the sql to say if<BR>VisitID exist.. do not append this record?<BR>Michael
Tells ya how to do the existing thing.<BR><BR>It won't append a record anyways if VisitID is your primary key, and you attempt to insert the same thing in again.
before inserting a visitID into the db, query the db to see if that visitID already exists. If it does, then shoot out a response.write saying the problem!!