>>I have a form with 3 views and a table that has a problem with it's data environment loading the views.
>>
>>the message I get is:
>>"Error loading file - record number 7. frmClientActivityReport . Loading form or the data environment: Index does not match the table. Delete the index file and re-create the index
>>
>
>In all probability, either a table in the .DBC, or the .DBC itself is out of sync with a .CDX, which could also be corrupted. I'd suggest that you delete the .DBC's DBX file, and try the following:
>
>CLOSE DATABASE ALL
>SET EXCLUSIVE ON
>USE DATABASE name of .DBC
>VALIDATE DATABASE RECOVER
>
>this will regenerate the .DBX, and check the various entries in the DBC against the tables and indexes that are referenced.

That should be
CLOSE DATABASE ALL
** then delete the DCX of the DBC
SET EXCLUSIVE ON
OPEN DATABASE name of DBC
VALIDATE DATABASE RECOVER

Just OPENing the database (or USEing it as a table) will recreate the DCX.
But the database needs to be OPENed, not USEd, to run the VALIDATE DATA.

Insanity: Doing the same thing over and over and expecting different results.