> Hello,
>
> I'm attempting to query a VFP database from Access 2007. When I try to import from a table using 'external data > more > ODBC database' I can choose the table from the database but I'm presented with an error message saying
>
> 'Invalid field definition 'DELETED()' in definition of index or relationship'.
>
> Any thoughts as to what's causing this would be much appreciated. I've successfully queried the database using Excel, but I'd like to be able to make more presentable reports based on the query.
>
> I'm connecting using the Visual FoxPro Driver under 'machine data sources'.
>
> Many thanks
>
> Jim

You have an index with filter expression using DELETED() function. e.g you want that your index should not show deleted records then u can use DELETED() function in the filter.

INDEX on cExp TAG ctag FOR NOT DELETED()

Regards,
Akram