disappearing text

[wolfe]

I didn't believe it either!

I made a db solution with several tables fields and all the standard stuff. One of the users recently complained that he had typed information into a standard text field, when he returned to the field later, the text was gone. "It just ate it" he said. lmao....sure it did! Well, I had to eat my own words, we run a spy program which takes screen shots every 15 seconds. I looked and sure enough he entered what he was suppose to, he left the record and created a new one and entered more information then closed the db went surfing on the web for about 45 minutes and when he returned, the text he entered in the text field was gone on one record but still there on the record he created after it!!!

This db has aduit tracking so I checked the aduit field to see what was up. The record showed several changes correctly, but did not show any change made to the text field with the missing data. Not even that he changed it from null to whatever.

This db is rather extensive, it has well over 50 tables and upwards of 500 fields and took forever to build. If your only answer is going to be rebuild the db, just save your breath. Drive over here and shoot me in the head and get it overwith!!!

I'm running a network of ten computers for a small police department. All computers run Windows XP Corp. I'm running FMServer7 on the server and FMPro7 on all the clients. I used FMDeveloper 7 to build the db.

Any ideas?

[andygaunt]

The field in question. Have you tried creating a new occurrence on the layout (not a copy of an existing field)

[wolfe]

Additional diagnosis.......

It seems that four different fields were affected by whatever caused this.

The first was a standard text field, the second was a time field, the third was a text field with a drop down list, and the forth was a calculation "audit" field.

I'm thinking this may have been some type of power surge or electrical problem but the system affected is on a UPS.

Does this help shed any light on the problem?:

HEEEEEELP!