Before Using Upsizing PRO!

Essential things you should check in your Access 2000 database BEFORE upsizing:

1. If the field size in an Access relationship is not exactly the same for both fields, the DRI constraint is not upsized - it is reported (cryptically) in the Upsizing Wizard.
2. Check for tables without a unique index
3. Check for spaces in table and field names
4. Check for Validation rules
5. Check for Unique index on a field and Required property set to no
6. Check for default values like "0.00" when a field type is double, single, long, integer or byte.
7. Check for large index on multiple fields. i.e. text fields that add up to more than 450 characters.
\
8. Check for fields that have more than 2 foreign keys because the table will be skipped.
9. Check for dates that are invalid.
10. The Upsizing Wizard can fail when upsizing a large table.
11. If you are using Access Replication, you should delete all the old system fields that Access Replication added.