SQL Server View integer field shows as text field in Access

[kevinfbutt]

Hi All!

I have an SQL Server View where my field in the view is an integer
field and works well. When I link to it from Access, the field is
defined as a text field in Access.

Does anyone have any idea why this is happening or how to fix it?

Thanks in advance!

KB

[Tom van Stiphout]

On Sun, 3 Aug 2008 20:31:43 -0700 (PDT), kevinfbutt
<ke********@iavalley.eduwrote:

That's quite unusual. Can you post the SQL for that field in that
view?
What version of Access and SQL Server? Fully patched?
Can you replicate the problem with a view in one of the SQL Server
sample databases?

-Tom.
Microsoft Access MVP

>Hi All!

I have an SQL Server View where my field in the view is an integer
field and works well. When I link to it from Access, the field is
defined as a text field in Access.

Does anyone have any idea why this is happening or how to fix it?

Thanks in advance!

KB

[bcap]

Is the column in the view the result of a calculation? If so, try applying
the CAST or CONVERT function to coerce the result back into an integer.

"kevinfbutt" <ke********@iavalley.eduwrote in message
news:16**********************************@2g2000hs n.googlegroups.com...

Hi All!

I have an SQL Server View where my field in the view is an integer
field and works well. When I link to it from Access, the field is
defined as a text field in Access.

Does anyone have any idea why this is happening or how to fix it?

Thanks in advance!

KB