Situation: FileMaker 11 server with about 45 users on a regular basis running on dedicated Windows Server 2008. Fast-Ethernet network.
Problem: Can't modify a field, add or delete, without killing everyone's connection. Coffee cup appears on their PCs. Calculation changes are basically impossible during working hours. I have to make my updates on a database copy and then make the changes at the end of the day with no one connected. Otherwise, the file will be forced shut by FileMaker server and a recovery of the file will be needed.
Is this the way it has to be? It's über frustrating.