Can someone please help us. We chose VFP 6.0 to migrate our DOS based clipper programs to Windows. The reason being that we would not have to change most of our old code and database structures. VFP coding (especially the databases commands) is very similar to Clipper.

Unfortunately, we realized too late that VFP can hanlde only 255 fields in a table. Our old clipper program uses databases that can go upto 1000 fields. If possible we would not like to split the databases. Is there any other way out, so that we can get VFP to recognize databases with 1000 fields. Our whole point to switch to VFP was that we would not have to mess around with the code too much as it has been running smoothly for the last 12 years or so. But with this field limitation in VFP the whole code and the structure of our existing client's databases will have to be changed.

We were not looking to move our databases to MSDE or any other format as that would mean changing our code to use SQL or appropriate commands. Currently we use old fashioned database commands like USE db, SKIP, SEEK etc. to access data in our code. Plus going to another database format would mean migrating all our clients' data (current and old backups) to the new format (which we were not planning to do as VFP had no problem recognizing clipper tables having less than 255 fields!).

Looking forward to a miracle.