Unfortunately doing this install makes no difference.

Also, the select command is super slow, i.e. on the order of a minute. There is an index on both part and serial.

I've just about given up.

Thanks for all your help,
Mike

>Have you tried installing the new ODBC drivers [version 2.5] from MS [MDAC_TYP.EXE]. This is just to simple a SQL for it to be failing as you say. I use the VFP ODBC to tap into a VFP DBC in a production app right now, and I never get such errors.
>
>Where is the DBC and tables located? On a Novell drive? NT Shared drive? Do the users have sufficient privileges/rights to access the files? On Novell, the minimum rights are Read and File Scan [R/F].
>
>>I know this is not the problem because I tried it with another table, that has two fields:
>>actdata,data_type
>>if I do a SQL select thusly:
>>select actdata from rawdata where data_type='PRD'
>>The same problem occurs.
>>
>>Thanks so far,
>>Mike