Hey people,

I just discovered a flaw in my db where when I try to perform maintenance on fmp8a, it says "file is damaged" and shuts down. If I try to recover, it crashes. I do have backups, but is there any quick way to detect bad data (like error logs) or something? I want to isolate the problem so it doesnt happen again.

I have checked for dupes in my unique id's and fixed that, but the file will not compact or clear empty blocks.

BTW I use SysDek, troi file, and dacons email plugins if that makes a difference. Hope this is not too scatterbrained, i've been killing myself all night trying to find an answer.

Thanks

blah

There is an updater on the FMI web site that you should download and install. See if that fixes it.

Steve

I have updated to 8.02, and still no difference. Is there any type of diagnostic utility for fm db's?

There is no tool that I'm aware off, but this sounds like a Filemaker bug...it shouldn't crash the system. I suggest you contact Filemaker.

Steve

Hi,

Corruptions can occur in your FileMaker files, although it is a bit less likely in the 7/8 format.

What I suggest is to export your data to a text file, and then import it into a clone of a backup prior to the corruption appearing.

HTH,

jd.

Thanks for the feedback,

Its just weird for me to be able to open the file and use it until I want to perform maintenance on it; then it crashes.

Wish there was a tool to analyze the data itself