>>>Does SQL Server work OK with VFP6 or do I need to upgrade? if so - how would you assess the upgrade problems?
>>>
>>>Thanks
>>>
>>>Colin
>>
>>Yes VFP6 works OK with SQLServer.
>>Yes you need to upgrade. In VFP9 you have CursorAdaptor class, which will help you to use both SQL and DBFs with same frontend.
>>Yes because VFP6 does not work with Vista
>>Yes, because there is XMLAdaptor and a lot of new staff which will make you life easier nowadays
>
>Jordan
>
>Thanks for that
>
>Any idea how difficult the upgrade is?
>
>Colin

Colin,

Check this reference, please:
http://www.berezniker.com/display/VFP/Moving+Applications+to+VFP+9.0