• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Access Query on SQL ODBC Connected DB character limit on fields

I'm running a query that returns multiple columns from multiple tables.
The query executes perfectly, but there seems to be a restriction on the amount of characters returned.

How can I increase this restriction in Access?
0
antonioking
Asked:
antonioking
  • 2
1 Solution
 
mbizupCommented:
What is your SQL statement?  Or at least the expression you are using for the fields that are getting truncated?

Take a look at this article for common reasons that Memo fields get truncated and some solutions.  The same reasons and solutions apply when linking to a SQL Server back-end:

http://allenbrowne.com/ser-63.html
0
 
antoniokingAuthor Commented:
How do I know if it's a memo field?
0
 
mbizupCommented:
SQL Server does not actually have a Memo Data type - but certain datatypes in SQL Server are seen as Memo fields in your linked Access database.

Try viewing one of the problematic linked tables in design view using your Access Database (instead of viewing it through SQL's configuration manager).  Do those problematic fields appear as Memo types in your Access Database?

I believe that anything over 500 characters will appear as a Memo field in Access.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now