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]

Re: SQL Server View integer field shows as text field in Access

On Sun, 3 Aug 2008 20:31:43 -0700 (PDT), kevinfbutt
<kevin.butt@iav alley.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]

Re: SQL Server View integer field shows as text field in Access

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 " <kevin.butt@iav alley.eduwrote in message
news:162bd7b3-e29e-4aba-bb57-e92bfd689684@2g 2000hsn.googleg roups.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