I had this problem to but was never able to find what was causing it. The
way I got around it was by doing execute statements like:
connection.execute("INSERT INTO .")
That way I avoided VB handling the updates and it worked. But since Josh
pointed this little problems "solution" out I might g
Tom -
I'll address what I can
I had the same problem with fields being truncated on direct connections (the
problem does not manifest on ODBC table attaches in Access).
IIRC, the way to "solve" this problem is to make sure the "optimize columns
widths" (option 1) in the ODBC properties.
