Base crashes after opening

Good evening
I am unable to use LibreBase - I’m on Windows 11.
I can open the database, but if I then try to open a table, query or other object I get the rotating circle for a long time and the object won’t open.
Thanks
kph

1 Like

Seems you couldn’t connect to the database. You only could open the Base GUI.

Which database type do you use? Internal HSQLDB? Then have a look if Libreoffice detects the right Java runtime environment: Install the correct JRE - LibreOffice on windows 10 / 11 - The Document Foundation Wiki

Same issue here, I think, and as in this topic . I’m migrating from MS Office 2017 to LO 25.2.4.3 (X86_64) on Windows 11 Pro (24H2) with JRE 1.8.0_451 (x86_64, registered), so both are 64 bit. Calc, Write, and Impress work fine but Base hangs almost immediately after I try and create any table. Any input would be much appreciated!

No Windows here, but one hint: HSQLDB is an internal database of Base. It will be unzipped when opening to memory. It will be zipped when closing. Data aren’t very save in this kind of database.

I would prefer to use an external Firebird database, which works directly with LibreOffice and without Java. Data will be written to the file independent of a crash or whatever happens to LibreOffice Base.
File → New → Database → Step 1 → Connect to an existing database → Firebird external
If the database doesn’t exist it will be created.

Only problem: You will get 2 files: A Base file for connecting to the database with all forms, queries and reports, and a database file. If you don’t want this you could choose Firebird as an internal database.
You have to set experimental features on for creating such an internal database:
Tools → Options → LibreOffice → Advanced → Enable experimental features
You only need this features for creating the internal Firebird database, not for using it. So it could disabled after you have created the file.

Reports will need Java, also some wizards. So you have to test if this solution works for you.

1 Like

Thanks @RobertG this is very helpful! I don’t mind having two files if the result is more stable. I just installed Firebird with default settings and the first tests are ok; I’ll be migrating my MS Access data to LO Base step by step. Thanks again!

You don’t need to “install” anything of Firebird. It will work with internal driver of LO.

1 Like