I am programming in VB6 and using Crystal Reports. When i make the Report i'm looking at a Access database ( \Testing\123.mdb ). But at runtime i may look for that database in ( \Real\123.mdb ) or ( \Another\123.mdb ) and so on. When i run my vb application, it will only look for the database in the \Testing folder. I want to be able to run the report and point it to the correct folder and database. The table that i'm looking at will be the same no matter which folder it is in.
Is there a way at runtime to point the crystal report to a different folder and database, then where it was created it from? I need it formatted at design time because there are logo's and other formatting in this report.