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:
  1. Set DBConnConfig = New ADODB.Connection    
  2. connconfig = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
  3.           "Data Source=" & App.Path & "\configura.mdb;" & _
  4.           "Jet OLEDB:Database Password=16051975;"    
  5. DBConnConfig.Open connconfig    
  6. Set rstemp = New ADODB.Recordset  
  7. rstemp.Open "SELECT * FROM [general]", DBConnConfig, adOpenDynamic, adLockOptimistic    
  8. Report.Database.SetDataSource rstemp
  9. CRViewer1.ReportSource = Report
  10. 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:
  1. CrystalReport1.Connect = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
  2.                         App.Path & "\configura.mdb;UID=sa;PWD=16051975;"
  3. CrystalReport1.DataFiles(0) = App.Path + "\rev_2000.mdb"

Please help!