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

Linked Table Data Type Problem

P: 47
I am linking a table in access 2000 back to a view in sql server 2000. When I create the linked table in Access the "Location" Field is defined as a number. The data in the Location field in sql 2000 is defined as varchar(25). This is causing a casting error in access.

Can anyone tell me why Location is being defined as a "Number" in access when it is defined as a varchar(25) in sql server 2000?

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

Expert 100+
P: 374
It sounds like there is an issue with the view in SQL Server 2000 that hasn't been defined correctly. Please check that out, you should be able to see how it is defined in the view.

If you would like, send me a copy of the view, and I can look it over.

Hope that helps,

Joe P.
Mar 20 '08 #2

Post your reply

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