?
Solved

Crystal reports 8.5 with access database - unable to use memo field , Crashes

Posted on 2008-11-14
7
Medium Priority
?
792 Views
Last Modified: 2012-05-05
I am not able to use memo fields in Access 2003 database with Crystal report 8.5. Application crashes giving error 20534, Error detectd by database DLL.
 We are directlly binding Crystal report to Access Database table fields. Any ideas.
0
Comment
Question by:pras_gupta
  • 4
  • 3
7 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 22964286
How are you trying to use a memo field?

They should display but you cannot use them in formulas except to test for NULL.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22964290
CR8.5 has a limit of 254 characters in a string.

mlmcc
0
 
LVL 1

Author Comment

by:pras_gupta
ID: 22964790
I am just using the memo field for Display , No formulas. It works fine if this is a string and till 255. I am dragging the Memo field on the Report from a Access Database.
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 200 total points
ID: 22965096
We used memo fields from MS SQL in CR8 with no problem for display.

Maybe Access is different.  What type does Crystal think it is?

mlmcc
0
 
LVL 1

Author Comment

by:pras_gupta
ID: 22965285
Crstal thinks it as a memo field. There are other memo fields being diaplyed correctly in other sections of report. This is a subreport in the mail report. It comes up file if the text doesn't break to a new page but fails if the text spans to a new page. It is not failing at 255 limit but can have more text than that.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22969198
Is it ever longer than 1 page in length?
If not you could try using the KEEP TOGETHER option on the field or the section

mlmcc
0
 
LVL 1

Accepted Solution

by:
pras_gupta earned 0 total points
ID: 22997926
I think we found the solution. The problem was not with Crystal but with Access not handling Memo field as part of composite primary key. Thanks for all your help.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

850 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