Do you use the Format and InputMask properties on a field?
SQL Server and MSDE have no equivalent to the Format or InputMask property in Microsoft Access 2000. As a result, neither property will be upsized when it is encountered by the Upsizing Wizard, nor will any errors be reported in the Upsizing Report. All formatting displayed as a result of using the Format property will be lost when the data is migrated to SQL Server or MSDE.
Do you use the AllowZeroLength property on a field (Upsizing Problem)? Do you use the Caption property on a field (Upsizing Problem)? Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)? Do you use the Required property on a field? Do you use a unique index and the Required property on a field? Do you have valid ValidationText property(Upsizing problem)?