an access table is linked to a sql server table. the table is populated from excel content imported to make a local table. after the local table is created (via import) vba code runs adds changes and deletes to the linked table from the imported table.
there are 4 long text fields in the linked table, those corresponding fields in the imported table default to short text.
when running an update, I check if the update table text is not equal to the linked table text and only update if they are different. however, I test for not equal, ie if update<> linked-table, then do update..... however it always returns not equal
I also tried strComp(update, linked-table, vb....) I tried all the compare options and always returns not equal
I also manually went into the update table and changed the 4 fields to long text from short text to match the linked table, and that did not make a difference, still always not equal
I also created the linked table recs originally from the same table that is now used (a second time) for the update. so the content in these fields HAS TO BE THE SAME... RIGHT?
the content is similar to this, folks entering comments etc so there is cr and linefeeds
"ANALYST for NOTE 34602 & 37722. HELPER INVOICE BILLED Erroneously. RAD 9944, 0076 (EC 3626)."
any ideas why the not equal?