Thanks Sergey I may just do that, any word on when a Non-Beta OLE DB Provider will be available for 7?

>The OLE DB provider from VFP7 is buggy. You've to download full VFP8beta to get VFP OLE DB provider. It's corrected version of the same provider but it still beta. At least you can find out if it's provider bug. I rememeber that there was problems with integer parameters in existing VFP OLE DB provider.
>
>>>I think that the main reason they are using parameters that it's more generic approch and doesn't required converting parameters into string to build SQL.
>>>
>>>What VFP OLE DB provider are you using? Try one from VFP8beta.
>>
>>We are not using VFP8 we are using VFP7. Is the OleDb for VFP 8 compatible with VFP 7? IF so can it be downloaded and installed separatly?
>>