With reference to the Subject title "Installation Problem" which I posted sometime back. I am now facing this error anytime I click on a command button to display a crystal report.

Note: The crystal report Member.rpt has already been designed with Crystal Report 8.0

1. In Component section, I have selected Crystal Report control.
2. I created a new form and placed a command button and crystal report control called cmisRpts.
3. Under the command button, I type the following
    cmisRpts.ReportFilename = App.path & "\Member.rpt"
    cmisRpts.DataFiles(0) =App.path & "\Members.mdb"
    cmisRpts.Action = 1

4. When I click on the command button, the following error displays:
    Runtime Error: 20534
    Error Detected By Database DLL.

This problem is really giving me headache. How do I overcome this. I really need Help!!

Kind Regards,

IKE

____________________________
IKBoye

Hi,
try with this where CrystalReport1 are your crystal report control!

With CrystalReport1         .ReportFileName = App.Path & "\rpt.rpt"         .Connect = "UID=;PWD="         .WindowTitle = "Anagrafica"         Classe.Stampa                    ' your SQL string         .SQLQuery = strSQL         .WindowState = crptMaximized             .PrintReport              End With End If

I think u should specify your db directly in the report

Bye
BRMC


____________________________
I don't mind not going to heaven
As long as they've got cigarettes
in hell

I managed to solve this problem by reinstalling Crystal Report by Clicking Add/ Remove and made sure i selected all the features under Data Access.

This has worked. Please spread this solution for anybody facing something similar to this.

This forum is really GOOD!!!

Kind Regards,
IKE


____________________________
IKBoye