Running Libreoffice version 4.0.4.2 on Windows 7 Pro
Installed newest version of Java (version 1.8.0_45)
The problem: I have a existing BASE file which connects to MySql. I am using the native MySql connector version 1.02 Mysql connector.
When I opened a BASE file, the message “LibreOffice requires a Java runtime environment...” message appeared.
What I did: So I click on Tools > Options > Libreoffice > Advanced and made sure the “use Java environment" was checked and the circle next to “Oracle Corp 1.8.0_45” was filled (not empty).
The question: I opened an existing BASE file. Usually I click on Edit > Database and see 3 options “Properties, Connection type and Advanced settings” The only available setting was “advanced options” (the rest were greyed out).
What is the solution to this? I must connect to MySql .