>>Does SQL Server work OK with VFP6 or do I need to upgrade? if so - how would you assess the upgrade problems?
>
>See Jordan's answers. He stated it perfectly.
>Go upgrade.

Any idea on any speed difference between VFP6 and VFP9 on handling a table of 500,000 records with 50 fields - would SQL be faster or slower than VFP?

Sorry if the questions are basic - have already converted our main app to VFP9 - hence the questions

Thanks

Colin