Hi,

I can access my protected mdb in the CR designer in VB6 via giving it the password when I make the connection via wizard but when I run the software it forgets the password and does not connect to the DB at run time. I am using Crystal Report 9

How can I supply the password in my code?

Hoping to receive an early reply.

Take care, Peace!

Try this:
Sub PrintReport()

    Dim Password as String
    Dim crxReport As CRAXDRT.Report
    Dim crxTable As CRAXDRT.DatabaseTable
    Dim mcrxApplication As New CRAXDRT.Application

    Screen.MousePointer = vbHourglass
    Set CRXReport = crxApplication.OpenReport( _
        App.Path & "\MyReport.rpt", 1)
    Password = "MyPassword"
    CRViewer91.ReportSource = crxReport

        For Each crxTable In crxReport.Database.Tables
            crxTable.SetSessionInfo "", Chr(10) & Password
        Next crxTable

    CRViewer91.ViewReport
    Screen.MousePointer.vbNormal

End Sub



Best Regards,

Al Weisenborn

Hello Bro,

Unfortunately this is not working and I get "Could not find installable ISAM" error message. When I hit the refresh button on the top it says "Not a valid password"

I know that the password is correct since the VB front-end using the password protected mdb is working fine; it's the Crystal Report that does not retrieve the data from the password protected mdb.

Note (just in case if there is a confusion): I am using a password protected mdb not a password protected Crystal report (the report object is in the VB designer and accessing via ADODB MS JET 4 engine).

Take care, Peace!