[[software:microsoft-access-table-optimizer]]

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

software:microsoft-access-table-optimizer [2018-08-05 04:25] (current)
Line 1: Line 1:
 +~~META:
 +creator = Brendan Kidwell
 +&date created = 2007-12-17
 +&date updated = 2007-12-17
 +~~
 +{{tag>​microsoft-access}}
 +====== Microsoft Access Table Optimizer ======
 +
 +{{ ::​icon.png?​nolink|}} 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¬†<​wrap sym>​_TableOptimizer</​wrap>​¬†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.
 +
 +---- dataentry software ----
 +Project Home Page_url : https://​github.com/​bkidwell/​msaccess-table-optimizer
 +Issue Tracker_url ​    : https://​github.com/​bkidwell/​msaccess-table-optimizer/​issues
 +License Type          : BSD
 +License_url ​          : https://​github.com/​bkidwell/​msaccess-table-optimizer/​blob/​master/​TableOptimizer.bas\#​L51
 +Description_hidden ​   : Quick and dirty procedure for optimizing the sizes of Text fields in Access tables (especially for imported data).
 +Icon_img ​             : :​software:​microsoft-access-table-optimizer:​icon.png
 +----