>I knew I had that question coming. 1000 fields does seem absurd, but unfortunately that is how the original program was designed. The databases grow dynamically not only record wise but field wise also! Yeah you read it right - field wise too! Our old DOS clipper program has been running without a hitch for the last 12 years, hence we don't want to reinvent the wheel if possible. I hope you understand.
>
>The reason to migrate to VFP is our old program is DOS based and sooner or later we will have to convert to windows. Unfortunately good old DOS days are gone. People would like to have that windows look. So the only code that needs changing is the user interface (screens) in our old code. All our database commands and functions work as is in VFP except for this major problem we have with the limitation of fields!
>
>Waiting for that bright idea which would not require us to make major changes in the old code. That is probably asking too much. Does anyone know if ver 7.0 will allow more than 255 fields?

No VFP7 doesn't allow more than 255. I remember we made a conversion to FP tables using dBaseV ODBC driver in the past.
Cetin