I've been trying to create remote views from VFP 6.0 sp5 on a couple of tables in MySQL using the MySQL ODBC driver for Win95.

The problem I have is that when you look at the field properties for character fields the largest size I can set is 20 characters even though it is 35 characters in the table. Even Access manages to connect (with the same DSN) and get it right.

Anybody got any ideas what I need to change in VFP to make it work?

Barry