>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.

EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

---

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys