Crystal Report XI Connection
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!