I've run across this before, but only in a table with a BLOB. I've selected half-a-dozen fields from a table, and one comes back as empty even though it's not. Putting in some code to debug, right after I read in the recordset the data is there, but when I try to use it later it disappears, even though moveNext hasn't been called and the recordset has not been updated in any way.
foo = rs("theValue")
if foo <> rs("theValue") then msgbox "db error"
' pops up db error every time
I'm concerned that this may be causing a problem that hasn't been caught yet. Does anyone here know anything about what causes this that would be helpful in avoiding it? I'm about to look for later drivers, but I couldn't find anything about this on MS's site.