Changing source table for all queries and reports

[bluke]

I need to change the primary data source table in my DB to a different table. The new table is an external linked table so i cannot just change the name. Is there an easy way to update all queries and reports to reference this new table??

Thanks.