hi,

so i have this field called "account id" in a table in access that i want to change the data type from number to text or vice versa.

i'm going to do this repetitively so i would like to build a sql or vba to make it easier for the users.

when i tried to do this manually, access gives me an error message:

"Microsoft office access can't change data type. there isn't enough disk space or memory" OR

this message "Some data may be lost. the setting for the fieldsize property or one or more fields has been changed to a shorter size. if data is lost, validation rules may be violated as a result. do you want to continue anyway? (Option yes or no)." -- if i say yes, another message will pop up: "Microsoft Office access encountered errors wile converting the data. the contents of fields in 4 records were deleted. do you want to proceed anyway?"

I'm just wondering what those 4 fields are. and why does access generate these messages when i try to change the data type.

Thanks!