Are you using OLE DB provider for ODBC or VFP OLE DB profider? According to VFP 7 help, INDEX and REINDEX commands aren't supported by VFP OLE DB profider.

>I've been trying to impliment a (simple) REINDEX from A Visual C++ application. The Applicaton uses ADO, and I use SQL to retreive Recordsets from TABLES. Most functions work (SELECT, INSERT, JOIN, DELETE, PACK, for examples) but I've been unable to REINDEX (or ZAP).
>
>INDEX, REINDEX, and DBREINDEX all typically give the "Access Violation or Syntax Error". As I can do other operations on the files, including PACK, I rule out Access Violation as the cause.
>
>Anyone know the syntax for how this is to be done? Right now, my only solution seems to be adding a record, deleting it, and then packing the file. Not very good for a general solution.
>
>Thanks,
>Balboos