OK, I solved this problem. It was something completely stupid and unrelated (as usual). The TextData columns had different sizes so it didnt want to insert. Once I changed that...

This is the error message I get:

"Violation of PRIMARY KEY constraint 'PK__tblEmp_Trace__025D5595'. Cannot insert duplicate key in object 'tblEmp_Trace'."

(@MaxRec + 1) doesnt actually increment @MaxRec so it remains the...