# How can I open a database created using Open Office in Libre Office?

I created a database using Open Office a few years ago and I am generally using Libre Office now. However I cannot open a database that I created using Open Office, in Libre Office. Is there a way that I can do this?

edit retag close merge delete

However I cannot open a database that I created using Open Office

Any error message, when trying to open?

( 2020-06-11 17:56:26 +0200 )edit

Thanks for reponding. Yes, I get an error message: "The connection could not be created. Perhaps the necessary data provider is not installed." At first I thought that Java was not installed properly as I had made changes to my PC, but now I have re-installed java it has made no difference.

( 2020-06-11 18:51:53 +0200 )edit
1

Hmm - reinstalling 32-bit java while using 64-bit LibreOffice won't help at all, since bitness must match. Hence more information is required to help:

• Which java did you install 32-bit or 64-bit?
• Which LibreOffice version do you use and which bitness (32-bit or 64-bit)?
• Did you assure that LibreOffice found your Java installation (In Tools -> Options -> LibreOffice -> Advanced is Java listed and Location shown)?
• Did you assure that it is really enabled (Option [x] Use a Java runtime environment)?

And please also mention the operating system you are using and the type of database (embedded HSQLDB?).

( 2020-06-11 19:09:36 +0200 )edit

Hi, I have just checked your queries, and: I have checked that I have installed 64 bit Java 64 bit Libre Office in use I have gone through your Tools etc link and the info says "ticked" Use a Java Runtime environment "Java runtime environment (JRE) already installed" but the location is not shown, and when I try to add the correct directory, I get a message to say that the folder I have selected does not contain a runtime environment. What file should I be looking for? The file I have chosen holds java.exe Operating system is Windows 10 Not sure of the type of database. How do I find out. By the way when I open the database in Open Office (which it does OK) I can find a reference to the JRE Regards,

( 2020-06-12 12:48:37 +0200 )edit

And you see the installed Java listed in the pane below the option and the radio button activated - similar(!!!) to this screenshot:? (don't mind the details - I'm using Linux).

( 2020-06-12 12:59:22 +0200 )edit

No, there is nothing in the Vendor / Version / Features box. When I try to "add" I lead it to the Jave folder in programs 64, but then I get the message that the folder does not contain a JRE.

( 2020-06-12 17:59:50 +0200 )edit

When I try to "add" I lead it to the Jave folder in programs 64, but then I get the message that the folder does not contain a JRE

I understood that, but in general it is not required to use Add functionality, since LibreOffice will detect a valid Java installation automatically. If the information doesn't appear of a Java installation automatically, then most likely using Add won't cure an existing problem. Hence:

What exactly did you install?

• Filename of your Java installation package
• Installation directory (into which path did your Java install)

(It seems definitely to be a problem of your Java installation)

( 2020-06-13 14:58:24 +0200 )edit