HeathRamos
IS-IT--Management
I am trying to append data to a visual foxpro table but keep getting the following error:
"You tried to assign the Null value to a variable that is not a variant data type"
I am trying to do this over an odbc connection in Access 2000.
When you run this query in Access 97, it works fine.
Keep in mind that I can update existing records w/o a problem.
Also, when I remove the fields that don't have data in them and try it again, it gave me an error about breaking a restraint rule and ended up appending a record with just the first few fields filled out.
"You tried to assign the Null value to a variable that is not a variant data type"
I am trying to do this over an odbc connection in Access 2000.
When you run this query in Access 97, it works fine.
Keep in mind that I can update existing records w/o a problem.
Also, when I remove the fields that don't have data in them and try it again, it gave me an error about breaking a restraint rule and ended up appending a record with just the first few fields filled out.
