Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - What's wrong with modifying the data type of a field in an Access database?
What's wrong with modifying the data type of a field in an Access database?
It may appear.

Type transformation

Error, resulting in data loss.

For example, when converting a text field to a long integer field:

If the field value of the original record is "1", it can be converted;

If the original record field value is "a", it cannot be converted and the field value will be deleted.