Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Memo field returning Null values

Posted on 2009-04-02
Medium Priority
Last Modified: 2013-12-25
I have an SQL query that pulls data from an ODBC connection to a system DSN I have set up.  Everything works fine until I try to add one more field.  The field is listed in the database schema as a 'text' field with a limit of 8001 char... so I am assuming it is like a Memo field in Access.  When I add that field, all the fields are returned as Null.  I know there is data in that field because I can query it in Crystal and get data, but when I use that same query in VB it comes back Null.  Help!
Question by:jmoran18251
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Author Comment

ID: 24051163
500 points and a six pack?  I'm dyin' here...

Author Comment

ID: 24051882
500 points and a twelve pack?!?!?!?
LVL 14

Accepted Solution

rejoinder earned 2000 total points
ID: 24056728
Have you tried to run the same select or query statement from SQL Query Anayzer?  It should return the same results as did Crystal.  If not, then we need to look at the select statement or the DNS connection you are using.
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24067871
Please post your code and database version.
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24067875
Also post the structure of your table.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

715 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