I believe, it is because of the updateable view you are using. Even you trim VFP data, it is stored in the view.field and accept the length of the view.field.
Perhaps you should use sqlexec(..., "INSERT INTO....) instead of the view here.


>As a result of an interface I am writing I have the need to insert records into an Access database from a foxpro application.
>
>I created a database container, a connection to the Access MDB using the ODBC access driver and a remote view connecting to one of the tables within the Access Database.
>
>everything works perfect except when I insert records into the Access MDB, the data within the fields has trailing spaces. I am trimming all data on the foxpro side but the fields on the Access MDB come up with trailing spaces, I don't know if is something the Access ODBC driver inserts or if there is a way for me to control that.
>
>If anybody has seen this before please let me know...
>
>thanks !