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.
I've been pounding my head against a wall for the last couple of days trying
to make a "simple" program work (to then use as the basis for future
programs, etc. -- in other words, "I'm still just learning this stuff") I'd
really like to "point the finger" at Microsoft & visual basic, but I've bee
