The question is with regard to erratic behavior of Upsizing Wizard.

In my own system I have either a Win 98 or a Win NT server for SQL
The Client (running VFP 7) is either Win 98 or Win 2000 Pro.

With this config I appear to have no problem upsizing to SQL so long as data integrity is solid.

BUT - when I go to my customer's shop, where I am running VFP 7 on a Win 2000 Server along with SQL 200 on the same machine, there appear to be difficulties which are difficult to understand.

For example, I have several short tables with less than 50 rows and all that works is the table structures are upsized (transfered) to SQL Server. No rows go across.
However, on one occasion - with no apparent difference in conditions, I did get a single larger table across (>5000 rows). But after that one success nothing else appears to work.

Typical error message in the error table in the upsizing report is that "4,861 records not exported"

Any help with this apparent difficulty would be greatly appreciated.

Dick Balluff
rlb@surewest.net
Office phone (916)789-8855