I have Access front end and SQL back end database. I am trying to synch 2
tables together, insert records from table1 into table2 if they do not exist
in table2, if they exist, then update.
The primary key is set to the empID. I have some records that need to be
inserted into table2, however, I am getting an error that can not insert Null
value, empID column does not allow nulls.
The records do not have any fields that are null so I am not sure what is
When I try to append those records in access, they append fine. But I really
need to get this to work in SQL. Can someone give me an advise on what may be