This error message can occur in many applications. In AOI the solution is to rename the AOI folder within the appdata, re-register the user and re-create data connections.
Open Windows Explorer. In the file path at the top, type %appdata% , press Rtn key.
Open the ‘AccessAccountingLtd’ folder.
Rename the ‘AccessOfficeIntegration’ folder to be ‘AccessOfficeIntegration_OLD’.
Open AOI Registration, refer to the article ‘How to Register the Client ’.
Note: At the last stage of the registration process, check the Company Name field is populated. If not, the user may not be registered correctly. Open AOI Registration. The ‘Access Software Registration’ window appears showing the ‘Start Page’. Select ‘Manage Access Office Integration users’, click Next. The ‘Manage users’ page appears. Select the user with the issue and click Deactivate selected user(s), click Finish. Repeat this process from step one using the original version of the AOI license file.
Open AOI Administrator, refer to the article ‘How to create Data Connections in AOI Administrator ’.
Open Excel and check if the Access tab is present.
If the issue persists, you may be missing a template, to remedy this, copy the same AccessOfficeIntegration folder from step2 from a working machine to this one to bring across any missing templates