Try something like this:
foreach ([forgot object name] tbl in CRReport.Database.Tables)
{
tbl.SetLogOnInfo("",dbLocation,dbUser,dbPass)
tbl.Location = dbLocation
tbl.SetDataSource(dbLocation)
}
I've not got CR installed here, so can't double check the function and object names, but I believe that will redirect your database source for you :) The first parameter of "SetLogOnInfo" i think is a connection string, but I don't think you need this when reading from Access.. I've only ever used SQL Server, so I will say this is all just guess work :wtf: Anyways, hope it works for you! :cool: