1 Reply Latest reply on Aug 16, 2010 2:22 PM by philmodjunk

    Making layout/database changes while system is live

    marketg

      Title

      Making layout/database changes while system is live

      Post

      I am just curious about this. We run a Filemaker solutions with about 12 databases running through out the work day. Is it safe to use a client computer or the server to log in as and admin user and make changes in a database while it is live and in use?

      Thanks

        • 1. Re: Making layout/database changes while system is live
          philmodjunk

          Best practice is not to. Your changes may catch a user "between chairs" when a layout's appearance or function suddenly change. In addition changes to table and field definitions briefly lock tables when you click OK to dismiss Manage | Database and apply the changes. If another user is running a script that modifies data in a record at the same time, it may fail to modifiy the data and no error message appears to tell that.

          That said, I do, carefully, make small adjustments to layouts and scripts of live databases and as long as I'm careful to consider the consequences, this works out OK.