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

SQL Server View integer field shows as text field in Access

P: n/a
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
Aug 4 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Aug 4 '08 #2

P: n/a
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

Aug 4 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.