>>>>OK, thanks. Do you know if the 32bit VFPOLEDB driver can be used from within a 64bit application ?
>>>
>>>No, 64 bit application uses 64bit OLE DB
>>>
>>
>>Thanks Martina - I guess there is no way around it ?
>
>Eh, check Advantage OLEDB driver (without warranty).
>
>or
>
>Will be crazy...
>- MSSQL Express 32 bit
>- enable 'Ad Hoc Distributed Queries'
>- grant execute xp_prop_oledb_provider
>- add linked server to DBF (VFPOLEDB driver 32bit)
>- add synonym for each dbf example: CREATE SYNONYM vfptable FOR VFP_LINK..vfptable
>
>- change connectstring from VFP to MSSQL in 64bit application
>
>
>MartinaJ

Thanks Martina - I looked now at Advantage but on running the OLE DB provider it requires the Advantage database to be installed (too much overheads for my needs - same for the MSSQL option). Thanks anyway :)