If you have any blanks or nulls in any fields, you might try putting in a space or something like that. Of you could export your test table to the iSeries, which should create it with the right data types (according to Access ;-)). Brian
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Null error with copy/paste function--Access table with iSeries
Collapse
X
-
Null error with copy/paste function--Access table with iSeries
I created a test table in MSACCESS and also a table with a "link" from an iSeries PF. Both tables having identical fields & sizes, when I copy from my "test table" and try to paste to the "link table", I receive this error: "You tried to assign the Null value to a variable that is not a variant data type." All data types in both the test and linked table are text types. Any thoughts? Diane
Comment