Changing table name at runtime ?

Hye,

My report was design on a Access DB (MyDB.mdb, table = Customer).

I want my report retrieve data from another table (XCustomer) with the same design as Customer but I can't change the table name at runtime...
If I have a table Customer on my SQL database all works fine but impossible with XCustomer !!! :ehh:

I've try with SetTableLocation but it doesn't works :mad:

So what can I do ?

Thank for your helpYou need to create other report designed using XCustomer and call it

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