[Solved] Databases won't run on a new iMac

[PhotoGuy52]

I just migrated from an older iMac to a new 2020 iMac. My Open Office text documents and spreadsheets run just fine but I get the attached error messages when I try to open an existing database or create a new one. I have the latest version of Open Office installed and the latest version of Java installed. I found out from Apple tech support that 2020 iMacs will NOT run any 32 bit software so a legacy version of Java isn't an option.

Update: The error message I was getting is VERY confusing! Do NOT go to "Tools" in the Open Office dropdown menus like it tells you to because the solution isn't there. Go to Open Office "Preferences" and then to the "Java" line in the dropdown menu. Once I selected the installed Oracle Java software everything worked just fine.

[RusselB]

Welcome to the Forums.
Since you have already determined that a legacy installation of Java isn't an option, my suggestion is to switch to http://www.libreoffice.org

[RoryOF]

Isn't the version of OpenOffice for Catalina 64 bit?

[PhotoGuy52]

OpenOffice for Catalina is 64 bit which is why my text and spreadsheets work. The problem is with Java.

[RoryOF]

Then you need a 64 bit Java.

[MrProgrammer]

The problem is with Java.

I cannot test MacOS 10.15 for you but read [Tutorial] Mac FAQ Q06/A06.

[Solved] User experience: OpenOffice 4.1.7 on MacOS 10.14.6

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.