2 Replies Latest reply on Jan 30, 2010 3:51 PM by TuxfordC

    Pruning a Database



      Pruning a Database


         I am planning to reduce the overall size of a smallish FM 9 database. It has less than 2,000 records and

         was used by two linked organisations. Now there is only one group using it on a LAN. Over a few years, the

         user interface layouts have become cluttered with unwanted Icons and instructions, and about half of the

         Scripts are obsolete.  Some of the redundant tables have hundreds of fields.


           To me, a way of doing this is to make a clone without records, remove all the unwanteds (of course the

          required fields will be retained), then tidy up the user interface and import the records from the original

          file.  Is this logical?