Connecting Crystal Reports to movable, non-fixed access database

[thesleepylizard]

Hi, I'm using Crystal Reports Developer 8.5.

I'm working on a VB6 project and using (ummm....) RDC (?) to design the reports within VB. (Not sure of the exact term there - I hope you know what I'm talking about)

Now... I'm using an Access database. I want the program to be able to run in any folder, so it doesn't matter exactly where it's installed to. So..... it should be able to run from C:\MyManager\, C:\Program Files\LizardSoftware\MyManager\, C:\Games\ManagerMan\ etc.... ALso the idea is that they can take the entire folder with program, database, and other files and copy it to anywhere else on their computer.

Now the rest of the program is fine - I can easily connect to the database using the relative file path (saying dbc.open ".......Database=data.mdb.....&quot. However, I don't know how to get Crystal Reports to connect to a local database and not require a full path!

Is this possible???

-The lizard

 

[080898pll]

Put dat file in same folder as the crystal report. Then check off same as report in crystal reports. Click the database menu item and click set location... and highlight same as report. This should allow you to have the database in any designated folder....