Seema;

I do not know where you are with this project. I know you want suggestions and nothing else.

VFP 7 also has a 255 limit. Would it be possible to use ODBC and continue to use the present Clipper tables? So you will not be using a dbc or buffering - just xBase commands to handle data. That would be like using VFP free tables. I have not worked with Clipper for eons. There may also be a driver for Clipper to do this.

What about MSDE or SQL Server? How many users?

Check out http://msdn.microsoft.com/vstudio/msde/default.asp for info on MSDE. The question then becomes how to get the data from point A to point B. :)

Tom



>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?