Hi,
I am a SQL DBA and have not worked much with Access. I have an existing Access 2007 database that has linked tables to SQL 2005 tables. There is a constraint on a table to eliminate entering duplicate values but no error displays in the Access form when it is triggered.
I confirmed that the constraint is working on the SQL side but when I go into the Access form and enter a duplicate value, it just disappears as if it was accepted but no value was entered into the SQL database.
Thank you in advance.
Isabelle