Solved

Access Query on SQL ODBC Connected DB character limit on fields

Posted on 2013-01-10
3
297 Views
Last Modified: 2013-01-24
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
Comment
Question by:antonioking
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 38762387
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
 

Author Comment

by:antonioking
ID: 38763397
How do I know if it's a memo field?
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38763466
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

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question