Conecting tables in different Databases

[Rubber Duckie]

Hi to everyone.

Does anyone remember VB5 and Crystal Reports 4.6.1.?

I created a report which invokes two tables that are in different Access Databases which are password protected.

The thing is that I Can´t find the way to point to the Databases when they are in other location than the used when the report was created.

I already try this but no success…

FormX.Cr1.DataFiles(0) = DbPath1 & "db1.mdb"
FormX.Cr1.DataFiles(1) = DbPath2 & "db2.mdb"

Your help will be much appreciated

Thanks in advance.

[jggtz]

Are You sure that DbPath1 and DbPath2 ends with a '\'

[Rubber Duckie]

Are You sure that DbPath1 and DbPath2 ends with a '\'

Hi jggtz , tahnks for you answer...

Yes, in fact

DbPath1 is C:\Proyectos\CopyJet2\Servicio\

and

DbPath2 is C:\Proyectos\CopyJet2\Factur 2.5.5\

[jggtz]

In my opinion the syntax is correct...
Check if you Save Data With Report,
Also, may you post your code (Printing routine) I would like to see how you are handling the password protection

[Rubber Duckie]

Thanks jggtz...

This is the code... the databases are now, Not password protected, so that´s not an issue for this problem.

With CR

For X = 0 To 10
.Formulas(X) = ""
Next X

.DiscardSavedData = True
.ReportFileName = "C:\Proyectos\CopyJet2\Servicio\rptSolicitudPartesPorReporte.rpt"
.DataFiles(0) = "C:\Proyectos\CopyJet2\Servicio\Servicio.mdb"
.DataFiles(1) = "C:\Proyectos\CopyJet2\Factur 2.5.5\Sifacbas.mdb"
.Action = 1

End With

I´m also observing the order in which databases must be asigned in the DataFiles array.

Thank you very much. I hope this can lead you to a clue

[jggtz]

Syntax seems ok
Only one thing ... Change the directory name "Factur 2.5.5" removing blanks and/or periods and give a try...

[Rubber Duckie]

HI jggtz....

At the end I found the key of this matter...

What happens is that in the DataFiles array, is created an entry of the database path for each table in the report.

Since in the report of this case are used three tables of the "Servicio.mdb" database, and two tables of the "Sifacbas.mdb" database, the DataFiles array must be:

Cr1.DataFiles(0) = "C:\Proyectos\CopyJet2\Servicio\Servicio.mdb"
Cr1.DataFiles(1) = "C:\Proyectos\CopyJet2\Servicio\Servicio.mdb"
Cr1.DataFiles(2) = "C:\Proyectos\CopyJet2\Servicio\Servicio.mdb"
Cr1.DataFiles(3) = "C:\Proyectos\CopyJet2\Factur 2.5.5\Sifacbas.mdb"
Cr1.DataFiles(4) = "C:\Proyectos\CopyJet2\Factur 2.5.5\Sifacbas.mdb"

And with this the case is solved

jggtz, I really appreciate your kind attention to this problem.

Have a great year!!!