>>I've only needed to use odbc to access other data from VFP. I have some dbf's that someone wants to use through MS Access. Shouldn't the current VFPODBC.DLL handle that for them? or is that the Access ODBC? They are having trouble and are quite quick to blame it on VFP, is this a VFP or Access problem?
>>
>>Could the problem be that the dbc is not with the tables?
>>
>>Thanks,
>
>Access 97 has a problem with VFP tables that have an index on DELETED(). Access 2000 with the current MS ODBC drivers do not have that problem.
It actually goes beyond that - the older ODBC drivers had problems with indexes on logicals in general.