Crystall With Password Protected MS ACCESS help!

[trumanrus]

hi im using crystal with ms access with password database, my problem is login dialog persist when i run the report on my vb application, im using crystal viewer 9 and vb 6, thanks a lot!

Dim lApplication As CRAXDRT.Application
Dim lReport As CRAXDRT.Report

Dim strselection As String

Set lApplication = New CRAXDDRT.Application
Set lReport = lApplication.OpenReport(App.Path & "\TestReport.RPT", 1)
cr.ReportSource = lReport
cr.Refresh

cr.ViewReport

[Hack]

Are you opening the database (and thereby passing the password to the connection string) before running the report?

[trumanrus]

ahh no, when i design/create the report i already set the password for the database so that crystal can connect and retrieve the db structure, do i have to specify the password when i call the report in vb? if so how can i?, thanks a lot!