Posted 17 December 2007 by Brendan Kidwell

Microsoft Access Table Optimizer

This module is a quick and dirty procedure for optimizing the sizes of Text fields in Access. One important use for this module would be cleaning up tables imported from external sources where Access defaults to very large field sizes.

The report script in this module creates a table called _TableOptimizer that lists the field size, size of shortest value, and size of longest value in the table you specify. Then if you want to resize any text fields, you can edit the report table and run the resizing script.

Project Home Page:
https://github.com/bkidwell/msaccess-table-optimizer
Issue Tracker:
https://github.com/bkidwell/msaccess-table-optimizer/issues
License Type:
BSD
License:
https://github.com/bkidwell/msaccess-table-optimizer/blob/master/TableOptimizer.bas#L51
Icon:
icon: icon.png