Hello,
I have 2 Access 2000 databases which have fields inserted in the Report. Im connecting with ADO and I cant seem to get it to work with
VB Code:
Set DBConnConfig = New ADODB.Connection connconfig = "Provider = Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & App.Path & "\configura.mdb;" & _ "Jet OLEDB:Database Password=16051975;" DBConnConfig.Open connconfig Set rstemp = New ADODB.Recordset rstemp.Open "SELECT * FROM [general]", DBConnConfig, adOpenDynamic, adLockOptimistic Report.Database.SetDataSource rstemp CRViewer1.ReportSource = Report CRViewer1.ViewReport
But since I have fields from the other database, it doesnt recognizes them.
In version 4.6 what I did was:
VB Code:
CrystalReport1.Connect = "Provider = Microsoft.Jet.OLEDB.4.0;" & _ App.Path & "\configura.mdb;UID=sa;PWD=16051975;" CrystalReport1.DataFiles(0) = App.Path + "\rev_2000.mdb"
Please help!




Reply With Quote