I tried the link posted above (
https://forum.openoffice.org/en/forum/v ... 74&t=69896), and I think I correctly followed the instructions, but the problem was not resolved.
The advice to avoid using wizards is good advice for the future, but the database I am trying to access was already created using the wizard. It worked fine until I updated to OpenOffice 4.1.1.
My gut feeling is that the instructions on that link were for older versions and that there is some sort of incompatibility issue between the latest versions of OpenOffice and JRE.
When attempting to the database, the following alert appears:
"OpenOffice requires a Java runtime environment (JRE) to perform this task. The selected JRE is defective. Please select another version or intall a new JRE and select it under Tools - Options - Java."
Upon closing that alert, this one pops up:
"The connections to the data source "Bob Personal" could not be established.
No Java installation could be found. Please check your installation.
Clicking on the "More" button reveals this:
"SQL Status HY000"
The version of OpenOffice is 4.1.1
AOO411m6(Build:9775) - Rev. 1617669
2014-08-13 09:06:54 (Mi, 13 Aug 2014)
The operating system is Windows 7 Professional, Service Pack 1
the computer was custom built, with Intel(R) Core(TM) Quad CPU Q8300 @ 2.50 GHz
Installed memory (RAM): 4.00 GB
64-bit operating system
Installed JREs:
jre-windows-i586.exe (probably 64bit because it is in Program Files)
In Program Files (x86) I found:
jre1.7.0_79
jre1.8.0_45
java.exe in the Jre7 folder
I also found an empty folder for jre6 (I will delete that folder)
In OpenOffice, Tools - Options - Java, after a few seconds, self populates with:
Oracle Corporation 1.8.0_45 and
Oracle Corporation 1.7.0_79