With Windows 7 and Office 2010 coming relatively close their support life-cycle end dates, our company are planning to move to supported releases, e.g. windows 10 and latest version of Office. We have a number of word macro enabled documents (docm) for workflows, as well as an Access Database application with front end purely built upon 2010. I am not a developer myself, but I suspect major upgrades such as completely new OS and Office versions may have adverse effects on these systems. Are there any general best practice guidelines on making the transition as smooth as possible specific to access databases to ensure they work as expected in the new releases, any specific tools that can be used in the testing etc. Or any general tips on such an exercise based on experience most welcome.
As a general observation, have you encountered many issues with word docm/access database applications when they were developed in a previous version of word/access, when you upgraded to a completely new version of word/access? Can you provide some examples of the scale of the issue, or was it relatively 'painless'.