AnsweredAssumed Answered

Pruning a Database

Question asked by TuxfordC on Jan 30, 2010
Latest reply on Jan 30, 2010 by TuxfordC


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?