To refresh the AppData please do the following:
Open a new File Explorer window.
Delete the navigation path from the Address bar at the top.
In the Address bar enter %appdata%. Press Rtn. The file path to the ‘Roaming’ folder appears.
Open the AccessAccountingLtd folder.
Select the AccessOfficeIntegration folder.
Right-click and select Rename.
Add ‘_Old’ to the end of the folder name. Click outside the name box to save the change.
The user will now need to be re-registered and new data connections set up.
If Access Analytics or Update templates have been used before the AppData refresh, they can be made to appear again by completing the following process:
Open a new File Explorer window.
Delete the navigation path from the Address bar at the top.
In the Address bar enter %appdata%. Press Rtn. The file path to the ‘Roaming’ folder appears.
Open the AccessAccountingLtd, AccessOffficeIntegration_Old, Version number folder, e.g. 5.10.18.
For Access Analytics templates, select the file AccessAccounts,AccessAnalytics,UserTemplates or for Update templates, select the file AccessAccounts,ExcelTemplates,UserTemplates.
Right-click and select Copy.
Navigate back to the AccessAccountingLtd folder and open AccessOffficeIntegration, Version number folder, e.g. 5.14.9. Right-click and select Paste.
Open Excel, select the Access tab, click Access Analytics or Setup Update Template.
Select Existing Templates and check the drop-down shows the templates expected.