Could be corruption. Try saving a copy as compact first. If that doesnt work, try recovering the file. If you get it working, then export the data into a clean clone backup.
Yep, I think the file is corrupted. I opened a backup from two nights ago and it worked fine. I'm just going to remove my current database from the server and load the clean backup. Then I have to redo two days worth of scripts and layouts.
Any ideas as to how my file was corrupted? I would like to prevent it from just happening again. Could it be a glitch in the FM Server, something I did when writing new scripts or data entry?
The biggest cause of file corruption is sudden loss of communication whether it be your server crashing, not closing down the files properly, hardware failure, network, loss of packets, etc.
FM Server currently resides on a desk top computer without the optimal software (better hardware has been on order for months). If it has been more than a day since the computer has been restarted then I can't open the Admin Console. Which means I have to restart the computer without closing the database and stopping the server. Do you think this can cause corruption?
Next time try executing command lines. fmsadmin close, fmsadmin stop.
You can find more details regarding them in the guide.
Also as a side note, the number one thing that you can upgrade for your hardware is the hard drive ( interface such as SAS of SCSI and RPMs ) as it is very intensive on the HD.
Although, I haven't restarted the computer this week and the backup from monday night is fine. I will look into it.
Thanks so much for your help!!