I am trying to run an append query from my access db to a linked BE table that is in SQL server. Whenever I try to run the append query I get an error stating "You tried to assign the Null value to a variable that is not a Variant data type". What exactly does this mean? Every field I am trying to append data to has a value so I'm not sure what it means by this error. Can anyone shed some light on this?