I have a client that I am experiencing some weird things going on and thought I would try running it by the UT to see if anyone has any thoughts on how to track this down.

Here's the basics:
1. VFP 7 (using Mere Mortals framework)
2. Using Views for all table updates. Some SPT, but strictly for reporting at this point.
3. Issue happens on entry into 3 different screens (no data in any cursor on entry, but never get to that point before it errors out).

Last Monday, they called saying they couldn't get into 3 areas of the system. These areas were specific to one table in particular. This happens to be the largest table in the system as well.

We corrected it temporarily by deleting a large number of old records dating back to 2000 and older. This is a temporary solution because they still need this data, but it corrected the problem at that time. Now we have the same thing happening again today.

However, today we also are experiencing a "Timeout Expired" error within Enterprise Manager on this table when trying to return all rows. There are approx. 181,000 rows and we have determined that we can return 80,000 but anything over that times out.

I suspect some level of corruption on this table, but don't know how to determine this, or how to correct it.

Does anyone have any thoughts?

Thanks,