Hello,
My company just upgraded from Sage 100 2015, to Sage 100 2018.
The installation path is different and we have a plethora of excel reports calling for data connections with the 2015 version.
Is there a fast and quick way to manage all these connections and change them to the 2018 path?
I have been changing every connection manually but because we have hundreds of reports, each with 5+ connections, the work becomes pretty tedious.
Thanks for any input you can provide!
Even with silent DSN's I know of no way to update paths other than copy / paste of the Connection string within each query.
Untested idea:
If you wanted to future proof things for your next upgrade, you might be able to set up something like MS Access Pass Through Queries in a permanent path (mapped drive). Excel points at the MDB. During upgrades (or server moves) update the MDB to point at the new Sage data location.
