I have a VFP 6 database that has been in use for 5 years. The application has worked fine until recently. The main table no longer allows new records to be added. Previous records can be modified, though. If I try to add a record, the form moves to the first record in the table and prevents me from displaying every other record. Exiting the application and reopening it will still only display the first record. Upon investigation, I noticed that if I open the main table in design mode and then sort on the primary index, a message is returned that the index is corrupted. After rebuilding the index, I can now browse the entire table and update existing records, but each time I try to add a new record, it corrupts the index and I am forced to rebuild it. The main table has 8530 records and the CDX file is 290 KB. I also noticed that if I open the table for read-only in Notepad, it looks like the new records are at the end of the file, even though they don't display when I browse the table. The application also use optimistic buffering.
Any thoughts?
Ryan Hirschey