So, let's take a step back here, as we need to understand where we are starting from.
Is this a data table that is already currently existing in Access?
Is it a linked table, or a "local" table?
Is it populated with data already?
Are you getting this error when you try to change the data type on the already existing, already populated with data table?
What exactly are all the current properties on this field?