>>>>>Just a mention (since I've seen this topic come up before) that I installed MSOffice7 today, and the VFPODBC 32-bit drivers work PERFECTLY with DBCs, complete with long field names, etc., in the Office apps.
>>>>
>>>>does it work w/ crystal reports?
>>>
>>>That I don't know yet -- we're supposed to get some copies of it when Congress passes our budget...
>>
>>lots o' luck... let me know when (if) you find out. vfpodbc drivers don't recognize the sql code that CR generates. not hard (for us) to modify, but not worth the time to teach the clients what to do.
>
>Wonders never do cease - I just came across a copy of CR 4.5. However, it doesn't seem to want to work with VFP, at first try. It looks suspiciously like the same trouble I've had in other 16-bit apps. I'll look at it some more when I have time...

it won't do anything with the 16bit version of CR4.5. it thinks it will with the 32-bit (using ODBC), but fails when it tries to execute the SQL.