Invalid Character Value for Cast Specification

[jschmidt]

Hi Everyone,

I am trying to link a table in MS Access 2000. When I create the table there is a field called "Location" that is defined as a varchar(25). The linked table shows the Location field as a "Number" and I get an error trying to convert the value "Side" to a column of data type int.

Does anyone know why this is being defined as an number in my linked table? Does anyone know if there is a way to change the "Location" field to be a column of data type "Text" in Access?

Thanks,
John

[jschmidt]

Sorry about the title of this post. I had a different problem I was going to ask about and forgot to change the title.

Sorry