• Home
 · 
• Miscellaneous
 · 
• Crystal Report Viewer for MS Access Database (Password Protected)

Crystal Report Viewer for MS Access Database (Password Protected)

Crystal Report Viewer.. How to Display a report in Crystal Report Viewer (MS Access Password Protected Database)..

Rate Crystal Report Viewer for MS Access Database (Password Protected)

• 1
• 2
• 3
• 4
• 5

(4(4 Vote))

Private Sub Report(ByVal rptname As String) 

Dim crxApplication As New CRAXDRT.Application

Dim Report As CRAXDRT.Report 

Dim a As Integer

Set Report = crxApplication.OpenReport(App.Path & rptname, 1)

For a = 1 To Report.Database.Tables.Count

 Report.Database.Tables(a).Location = App.Path & "\database\XXX.mdb"

Report.Database.Tables(a).SetLogOnInfo App.Path & "\database\XXX.mdb", "XXX.mdb", "admin", "pwdhere"

Next

Set frmReport.report = Report

frmReport.Show vbModal, Me 

End Sub