Change data-source name across all mail merge masters

[RonBaker]

Hello,

I’m in a situation where I need to switch the name of the data source on my system, however, I currently have hundreds of reports all pulling from the same data source. Is there a way to quickly change the linked data source accross all; reports? The database, table, and field names are the same, it’s just the data source name I need to modify.

https://imgur.com/a/6C9Gwbw
For example, “office2020.odb” needs to become “main.odb”

[dougmn]

If the data source is a table, maybe you could make a dummy table with the old data source name, and use a query to re-populate it with up to date data whenever you need to run the reports. If the data source is a query, the solution might be simpler: a query with the old name that draws on the relevant data from the table or query with the new name.