Hi I happened to be nearby when data disappeared again. It was around 5:00 PM. About 141 patients had been entered. From Patient No. 122 the child records were not there. The moment they found out they asked me to come. I made a copy of the database. Then the operator showed me wherby he entered a new dummy patient with one dummy child record and saved it. The record saved plus the child data of all the other records which was not there sometime ago came back.
I tried the same with the copied database. It accepted a new record but the old records did not come back. Any Idea. RAM ??? CACHE ??? HDD ??? Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" ----- Original Message ----- From: Ajoy Khaund To: Profox Sent: Tuesday, September 18, 2007 8:48 PM Subject: VFP6 Data Disappearing (Corrupt) Hi I have an app in a pathology lab. Its a multiuser app with generally new patients been entered from two pc's in the reception and another one or two pc's are used for reporting. The patient details are kept in PatHead while the tests to be done are kept in PatLine. Another table for Payments received. From the reception these three table are mainly used. From the inside PC reports are stored in different tables but the "Patline" table is also updated whenever a test is reported and saved as done. The app has been running smoothly since 2002. The pc's are the same, network wires, hub are all same with win98. Of late the data in Table "Patline" has started disappearing now and then. The reporting guy says that when he enters a valid patientid the app shows no record by that number. Then they check in the reception PC. The header record in table "Pathead" is there but the records in table "Patline" are not there. They gave me a copy of the affected database and there are few records in table "Patline" without any data but the cells appear to have barcodes which disappear when you click on the cell. Interesting they have discovered a cure which accoring to them whenever this happens they add a dummy record in the reception PC and the records which had disappeared comes back. I tried that with the data they gave me but I did not see that happening. The tabled do not have much data. The app is more or less what it was five years back with minor upgrades. The problems have started from this year. I wonder why this is happening. Any help to put me in the right direction will be highly appreciated. TIA Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785 001 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
