Automation Error Exception Occurred

[mikezhel1987]

Hi everyone I would like to ask a help regarding on Automation Error Exception Occurred. I have created an Excel application. Excep as a front end and Ms Access as a backend. Basically all the data that will input in the Excel userform will be exported to Ms Access. The application is running fine in my laptop. I am using a Windows 8 Os and 2016 Excel. However when I deployed the application to my colleagues it is not running and the "Automation Error Exception Occurred" pops in. When I exit the message box the Excel application will crashed. Is there a way to fix it I've been trying to debug the code but Excel keeps crashing as soon as the error pops out. My colleagues are using Windows 10 and Excel 2016. My question is why is that the application is running fine in my laptop but when I deployed it errors like that appears? Could it compatibility issues?

Thanks so much in advance for your help.