UPDATE : Some users now complain about very long time to open forms that were nearly instantaneous before.

>We need help here because we're at a complete loss over how to solve a serious bug. Some records are "invisible" to the application ou, in the contrary, the same record is returned more than once. Let me explain :
>
>- User add a category
>- The new category doesn't appear (if I open the table in VFP, I see the new record)
>- User add the same category
>- The system allow the category to be inserted even if the validation code explicitly verify that no duplicate can be added
>- The category now appears twice to the user
>
>Another example :
>
>- User add a garantee
>- The new garantee appears twice to the user (if I open the table in VFP, the record is there only once)
>
>I used the category and the garantee in my examples, but the same behaviour can be observed anywhere in the application. If the user close the application and reopen it, all the data is displayed normally.
>
>Like I said, this problem occurs in many different forms, in many different tables and on many different computers. Often, THERE WERE NO MODIFICATIONS MADE TO THE CODE OF THE FORM DISPLAYING OR ADDING THE DATA in the last months or even years. The application was working great for many monts/years and out of the blue, they start to show strange behaviour. The logic of displaying and adding the data is different from one form to another. We do not use table or record buffering.
>
>I suspected a database corruption, so I took an old database, put it in production, ZAP all the data in all the tables and import back the data. Didn't solve the problem.
>
>Our next step would be to try to move the dabase to another server, but I'm sceptical that it will change anything.
>
>I can't see why a record that physically exist in the table cannot be seen by the application with restarting it. Even closing and reopening the form doesn't solve the problem, the user have to shut down the entire application.
>
>Anyone can help us here ?