We have a FMP 7.0 v3 Database with about 700 records. Yesterday morning, the window was open on the desktop (with a record showing), and my wife closed the window with the "X" in the upper right corner as usual. Her computer runs Win 2000 Professional.

An hour later, I double-clicked on the database and it opened with "0 Records". ALL of the records, and scriptmaker scripts, were gone! The layouts were all there. The file size was 24K, previously 1.6MB. There was nothing in the trash, and ScanDisk showed no errors.

Anyone know any possible way this could have happened?

Last backup was a few days older than we would have liked...

I have used Filemaker since version 3, NEVER had anything like this happen.

by chance have you tried a "Show All Records"?

FMP 7.0 v3 has some very strange quirks, one of which is dissappearing parts, so what you describe is very possible

Also, FM7 will gladly open damaged files, which you may have

Try "Recover". It might at least bring back the data

Either way, you must revert to your last backup

PS

Make sure there are no duplicate files on your HD with the same name. Data often appears "lost" when a duplicate copy is opened by mistake.

Edited August 30, 200520 yr by Guest

I have had a problem like this with FM4 runing on Win98 some years ago, may be 5 years. I rememmber that a script was runing and it stucked, I had to close it by force. When I opened it again ... oh a lot of data where missing. Fortunately I used to make backups, but still a recovered a lot of the data manyally working for two days 18 hours a day.

I blamed on that time Windows, because along with the FM records, other files on the same harddisc where the FM file was, where disappered.