Linked Table Data Type Problem

[jschmidt]

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?

Thanks!

[PianoMan64]

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.