I get this same problem when writing to Oracle tables with VFP Remote Views, and I'd like to know if anyone knows how to prevent this as well. Maybe it's the same solution for both Oracle and Access?

>I am writing to Access2000 using the ODBC drive and VFP7. The data gets written correctly, but somehow it always gets written as the maximum field length for the Access Table. In other words, if Name is the Access Field name and it has a max width of 50 and I attempt to write 'TOM' into name the lenght of 'TOM' in the name field is always 50 rather than 3. Is there any way around this? Thanks.