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?