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 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 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.