Changing the column to the selected data type will delete its indexes and all relationships it participates in.

Microsoft Office Access 2003

Changing the column to the selected data type will delete its indexes and all relationships it participates in.

The column whose data type you are changing participates in indexes or relationships or both. But the new data type you supplied cannot accommodate participation in indexes or relationships. If you proceed, the data type will change, but the existing indexes and relationships will be lost.