I am struggling with the same thing. I have searched the whole world wide web, without anyone having the same problem or a solution.

Please try downloading and installing Microsoft Data Access Components:
https://www.microsoft.com/en-ca/download/details.aspx?id=5793

If the operation continues to fail after you've installed and rebooted, please check the Event Viewer for additional information.

Hi Marios.

A guy called Philip Nel gave me the answer:

A simple fix, change regional settings to English Europe and it works, i think the mdac drivers is set for English Europe, one can still set your formats to what ever your settings should be like 2 decimals, Currency symbol, date format and measure settings but must use English Europe for Regional settings and make sure you have a "," as list separator

Hi 13381622.

A guy called Philip Nel gave me the answer:

A simple fix, change regional settings to English Europe and it works, i think the mdac drivers is set for English Europe, one can still set your formats to what ever your settings should be like 2 decimals, Currency symbol, date format and measure settings but must use English Europe for Regional settings and make sure you have a "," as list separator.

But thank you for your assistance as well.

Hi Edwinvds, 

Thanks for sharing what worked for you. Ran this by the team as well who said that yes, Regional Settings are important, Access cannot be viewed when regional setting are set to French for example. Rather than EU they mentioned that It has to be set to English US. Perhaps this is related to your location.

They also advised that ’if your IT or someone accidently uninstalled Microsoft Office Access Database Engine 2007 (English) from the control panel, then they have to run a repair or reinstall Sage 300 to get Microsoft Office Access Database Engine 2007 (English) to reinstall again.