About changing Field-Types:
Seems to be quite difficult! (Access does not allow Field.Type to be changed after having been added to TableName.Fields .)
Suggestion:
Create new field with better Field Type, copy all contents of bad field to new field, delete bad field, rename new field as...