Migrating Microsoft Access 97 applications to Access/2000 is works fairly well. Certain complex conditionals
don't compile, but these expressions can be fixed fairly quickly. Most of the rest of the process is
Enterprise Manager Table Designer does not provide slots for adding any more than 255 columns. For
large tables, it is necessary to use a 'bag of tricks' to change the table definition and migrate data.
In some circumstances a developer or database designer is stuck with a situation where it is necessary
to extract data from a very wide (unnormalized) table and put groups of these columns in succeeding rows.
The Access form creation wizard brings in bit fields (or yes/no columns) as textboxes, when the user typically wants
check boxes. For a form with a large number of these, this wizard can be used to 'clean up' the form.