By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Invalid Character Value for Cast Specification

P: 47
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?

Mar 14 '08 #1
Share this Question
Share on Google+
1 Reply

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

Mar 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.