How to make the connection to DB dynamic - CR9

[VBFnewcomer]

Hi folks,
..Project\application\Database\mydb.mdb
..Project\application\Reports\myreport.rpt
the above is the structure how my db and rpt is organised in relation to the application developed in VB.
In the evening I copy the whole proj on to a CD.
Everyday when I sit to design/modify a report, I do it on a system whichever is available, so I simply copy the whole proj in to the available system. The problem is everytime I change the system, and open the report in CR9 I need to again set the connection/db settings (the one which asks for location of db etc) for every report created/modified earlier in another system. I was wondering, since the relative structure between the db and report is remaining same, is it possible to make the connection/db location dynamic. This would save me a lot of trouble.
Does anyone know how this can be done.
db: Access 2003
Report: CR9

Thankyou.

[mabbas110]

I have two methods , one that u make dsn and get report connect with dsn , so u dont need to update any thing , just when u want to use report in any new system , just create dsn and it will working fine.

secondly put report and mdb on same path and then make the connection , so u dont need to define db connection again and agaiin , just copy paste and u r done

i will prefer first method.

[mabbas110]

Please rate it if it had helped you out.

[VBFnewcomer]

Iam thinking something like relative paths.. any other ideas....