>I received an internal consistency error message and then a message saying an error had occurred in FoxPro and I closed it. When I reopened FoxPro and then my project, all of my remote views, and my connection to my SQL server 7 were gone! I then tried to create a new connection and it said no database was open, when I tried to open the database I got another error: Index does not match the table. Delete the index file and re-create the index. Has anyone ever run into this or know what I can do?

You may have to delete the DBC's index file [erase mydbc.dcx]. Then you can open mydbc exclusive. Then issue a validate database recover command.

After deleting the index, you can also able to open the DBC as a table, set deleted off, and look for your deleted views [i.e., deleted records]. Just work on backup copies of the DBC and DCT. Be careful what you undelete, use vaildate database recover often.