Before Using Upsizing PRO!
Essential things you should check in your Access 2000 database BEFORE upsizing:
- 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.
- Check for tables without a unique index
- Check for spaces in table and field names
- Check for Validation rules
- Check for Unique index on a field and Required property set to no
- Check for default values like "0.00" when a field type is double, single, long, integer or byte.
- Check for large index on multiple fields. i.e. text fields that add up to more than 450 characters.
\
- Check for fields that have more than 2 foreign keys because the table will be skipped.
- Check for dates that are invalid.
- The Upsizing Wizard can fail when upsizing a large table.
- If you are using Access Replication, you should delete all the old system fields that Access Replication added.