How To Change Database of Crystal Report

[slinko]

Hi All,
I am opening a crystal report(v8.5) in VB which uses bound fields to an Access database table. However when I move the database file or change the directory, I get an error when it tries to view the report. I checked other posts and found a lot of references to

Report.Database.Tables.SetLogInInfo

however I can't get it to work. The database file is on the local drive, not a server. I also read a post in the VB general discussions area that said that changing an Access database at run time is not supported. Any info would be greatly appreciated.

 

[FoxG]

Hi Slinko,

Within Crystal you would do it via
Database...
Convert Database Driver...
re-link to access ODBC Driver...
re-select the required file from your PC Directory.

No idea how you would do it via VB !!

Hope this helps,
Geoff

 

[casman2]

I have a DLL I created using these functions automatically, so I don't have to write this in every program. Here is the syntax I use:

Private CrystalDatabase As CRPEAuto.Database
Private CrystalTables As CRPEAuto.DatabaseTables
Private CrystalTable As CRPEAuto.DatabaseTable

Set CrystalDatabase = CrystalReport.Database
Set CrystalTables = CrystalDatabase.Tables
For TableCount = 1 To CrystalTables.Count
Set CrystalTable = CrystalTables.Item(TableCount)
CrystalTable.Location = DataFileLocation
Next TableCount


Hope this helps

 

[slinko]

casman2, Thanks for pointing me in the right direction, my problem has been solved. I was trying to access the tables, not the items of the tables collection. Thank you very much!!!!!!B-)