>>>Hi everybody,
>>>
>>>I have a quick question:
>>>Can we use VFPOleDb 9 with VFP8? Or should we download it for the version 8? If yes, can I also have a link if this is not too much to ask?
>>>
>>>Thanks a lot in advance.
>>
>>I think that you shouldn't have problems at all, though I never test this.
>
>The question is: when the VFP OleDb provider is used? Presently the only place we're using it (AFAIK) is the new functionality I implemented for creating Excel file. Do you think we can safely install it?
>
>In the meantime the problem with Excel is solved for one particular user.
You query VFP tables from within Excel? I think there should be no problems to install it (Unfortunately I have no computer where only VFP8 is installed to test it). If you send SET ENGINEBEHAVIOR 80 before your query made your query VFP9 compatible you shouldn't have problems. Again I never play with it so I can't be sure. But VFP OleDB 9 must work with VFP8 tables.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.