Has ANYONE had any luck opening a Crystal Report through VB6, which is based on an Access.mdb, that is password protected?
I am getting an error (CR type error):
Run-time error '-2147189176(80047e48
Logon failed.
Details: DAO Error Code: Oxbd7
Source: DAO Workspace
Description: Not a valid password.
VB Code:
strConnectS = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & App.Path & "\DB\MyDb.mdb;" & _ "Persist Security Info=True;" & _ "Jet OLEDB:Database Password=MyPassword" With CnnStatusS .CursorLocation = adUseClient .Open strConnectS End With Set rsS = New ADODB.Recordset Set objApp = New CRAXDRT.Application Set objReport = objApp.OpenReport(App.Path & "\Db\" & RptSelect & ".rpt") With objReport Set objExportOptions = .ExportOptions With objExportOptions .DestinationType = crEDTDiskFile .DiskFileName = App.Path & "\Temp\Report.pdf" .FormatType = crEFTPortableDocFormat .PDFExportAllPages = True End With .ReadRecords
the error occurs on the .ReadRecords
yes, I have checked the password.![]()




Reply With Quote