MEMO / TEXT / VARCHAR(>255)
Depending on the version of your MDAC driver, and the database you are connecting to, these columns can either (a) not show up at all, (b) only show up the first time they're called, or (c) cause 'Unspecified Error', 'Exception Occured'or 'Errors Occurred' runtime errors, if the following recommendations are not observed:
Avoid SELECT * notation; NAME your columns in a list, and name the offending column(s) LAST.
Assign the value of the column to a variable IMMEDIATELY, and only use this variable from that point on.
Make sure your MDAC drivers are most current (Microsoft Data Downloads).
See KB #200124 and KB #175239
Commercial-Free !!!