Appendding to/from Upsize_ts (time stamp) field

[Imran J Khan]

I am working with MS Access 97, with a SqlServer linked tables. I need to
append data from tblA to tblB, both of them link tables.
I created a new Append Query, but the append fails, I think because of the
Upsize_ts field, a time stamp field created by SqlServer. The error is " You
Tried to assign the Null value to a variable that isn't a Variant data type."
I need to get around this.
Thanks in advance.

 

[John W. Vinson]

I am working with MS Access 97, with a SqlServer linked tables. I need to
append data from tblA to tblB, both of them link tables.
I created a new Append Query, but the append fails, I think because of the
Upsize_ts field, a time stamp field created by SqlServer. The error is " You
Tried to assign the Null value to a variable that isn't a Variant data type."
I need to get around this.

Simply don't append anything to the Upsize_ts field, and don't reference it in
your Query. SQL/Server assigns this binary value automatically when the record
is created or modified, and its value isn't meaningful outside that context;
just ignore the field and let SQL manage it in the background.

 

[Imran J Khan]

Simply don't append anything to the Upsize_ts field, and don't reference it in
your Query. SQL/Server assigns this binary value automatically when the record
is created or modified, and its value isn't meaningful outside that context;
just ignore the field and let SQL manage it in the background.

That does not work either. Just FYI, the upsize_ts field is a binary field,
I don't know if that makes a difference.

 

[John W. Vinson]

That does not work either. Just FYI, the upsize_ts field is a binary field,
I don't know if that makes a difference.

<shrug> It works fine for me in the four databases which use upsize_ts fields.
Perhaps you could post the SQL of your appedn query.