Alternative to LibreOffice Base for Ubuntu 3 answers I have a web-based MySQL database, which is very important. I have used the MySQL Connector to allow me to use an MS Access database to query, and clean up my database, through an ODBC connection. A lot of it has to do with how the data is structured, though. So if you could give a clearer idea about that aspect of things (rather than 'rows' and 'columns'), you would get more help from the database/spreadsheet experts (I'm not one of them!) that give such generous help here.
Posted by2 years ago
Archived
Downloaded LibreOffice via the 'Alternative Software Solutions' on left. When I tried to use the Database, after going through all the panels to set up a new db, hit 'finish' and a panel popped up with the message, 'jre required'
Not knowing what jre is, I googled the term. Java Runtime Environment.
From what I could gather, most I did not understand, this is a know issue/problem, with LibreOffice Base.
Can anyone shed some light on what this is or better yet, how to 'fix' or get around this 'problem?'
Thanks
5 comments
I have a MS Access 2003 database on a Windows 10 PC running WampServer 2.5. I can open it in LibreOffice 5.1 Base. I added a test table with LibreOffice Base, consisting of the following fields:
idword
The first field (id) is an integer field, and is autoincrement (set to AutoValue).The second field (word) is varchar.
I saved the table, and then opened it. There are no input fields showing. If I click on Insert/Record, the Record link is greyed out.
To open the Access database with LibreOffice, I did the following:
- Opened LibreOffice
- Selected Base Database
- Connected to an existing data of type Microsoft Access
- Browsed for the Access database
- Selected not to register the database, and to open the database for editing
- Named the .odb file
- Opened the database table
- Tried to edit a record, without success
I can create a database as HSQLDB Embedded with the same table and fields, and everything works as expected.
What am I doing wrong? Any thoughts?
Thanks in advance.
John
John Rand
John Rand
![Tutorial Tutorial](http://panduan.blankonlinux.or.id/wp-content/uploads/2015/12/selection_0012-300x229.png)
5402 gold badges8 silver badges18 bronze badges
1 Answer
Well, in my particular case, the answer was to open the 2003 Access database with ODBC. There are good explanations here: How to Connect to a Microsoft Access Database
![Libreoffice Libreoffice](/uploads/1/2/4/9/124967816/385331606.png)
Here are the steps I took:
-
Connect to an existing database, choose ODBC, then Next
-
On Database Wizard sceen, it asks the name of the ODBC data source on your system. Select Browse
-
On the Data Soure screen, select Organize
-
On the ODBC Data Source Administrator screen, select Add
-
On Create New Data Source screen, select a Microsoft Driver (among different drivers and languages), then Finish
-
On the ODBC Microsoft Access Setup screen, type in Data Source Name, Description, and Select database, then OK
-
On the ODBC Data Source Administrator screen, select the User Data Source you just set up, then OK. The dialog closes.
-
On the Data Source screen, select the data source you just set up, then OK
-
Next Password, if you are using one
-
Next screen, 'Yes, register the database for me' (which may not be needed here) and 'Open the database for editing', then Finish
-
Next, give the .odb a file name and save it.
That's it.
John RandJohn Rand
5402 gold badges8 silver badges18 bronze badges