Changing database Path at runtime

Hi,
Plz help me.
I have created a report with MS Access, "C:\House\house.mdb"
I want to change database path at runtime to "D:\program files\House\house.mdb".
How can i make it possible? i am not using DSN, am writing direct code to open database.

Advanced Thanks.

bye,
kandula.Try this...

report.database.tables.item(integer).setdatasource dataenvironment(command)

Example,

Report1.Database.Tables.Item(1).SetDataSource DataEnvironment1.rsCommand2