Creating report without knowing database location

[Robbie_UK]

Hi,
I just got Crystal Reports 10, and I'm a total newbie with it. I hope you can help me. Please excuse my inexperience and sily questions :(

How would I change the database source at runtime for a report created with Crystal? I'm using a Microsoft Access 2003 database to store some information which I would like Crystal to use in a report. But the location of the database file is unknown untill installed on the end users computer. I'm using VB6 and so far to locate the database file I have been using the code

DatabaseLocation = app.path & "\organiser\axgo.mdb"

Is it possible to change the database location for the report using this? I'd be very grateful for any help you can offer :)

Thanks in advance

- Robert

[SkiNLaB]

course it is possible

im using crystal reports 9, and the way i did it was something like report.datasource.tables.setDatabaselocation

just browse through the report's function library, u'll find it.