1) I get the error even if I have already pressed the save button. That is why I am not sure why what it is trying to update if that is where the SQL error is coming from!

2) I don't have any buffering on my tables.

3) I don't have any code in the QueryUnload event.

4) I will have to try testing #4

Thanks for the advice!