Damage in your file could cause the crashing. Test a recovered copy of the file and see if it works without crashing. If so, you should replace your file with an undamaged back up if at all possible.
One other concern:
"We have a dedicated G4 Mac remotely sharing the Files to our Computers"
Do you have filemaker or filemaker server installed on this computer so that other's connect to the database using open remote? If your user's are not, but instead navigate to a shared drive and launch the files by double clicking its icon, that could be the source of the damage to your files as filemaker databases should not be shared in this fashion.
FMP 6 on G4 Mac FMP? FPMAdv? FMPServer? You do not specify.
FMP 6? version? You do not specify.
OS on G4? OSX 10.3? 10.4? 10.5? You do not specify.
Do you do backups before you change the database?
Do you do a Save As Smaller? or a Save As Clone?
What is the age of your last backup?
Have you tried to revert to known good backup with import from current DB?
Do you do monthly maintenance on the computer? (I recommend AppleJack)
Thanks for the help,
We have a copy of FMP server 5.5 (but to be honest, im not even sure we use it)
All the computers open remotely. We have migrated the files once before (maybe over a year ago now)
as we had an old Xserve (10.3) but it crashed
The G4 is running 10.4.11
theres around 25 different files that all link to the Database.
they all play there own little part (our database is mostly for keeping track of jobs and creating quotes)
Apparently the boss told me its was happening even with the server.
Talking to a few of the staff,
They told me the message when it crashes was a "communication error"
and then it would quit.
So maybe that might be a start?
Anyway thanks for the help so far
Hardtware it is running on G4
Software it is running on? You do not specify.This is KEY.
Client software using to access the server?
Specifics are impotant.