Membuat Aplikasi Desktop dengan Database LibreOffice Base 2 Dec 2015 Destop, Pemrograman, Perkantoran membuat aplikasi java dengan database LibreOffice Base resarahadian Jika menggunakan OS Windows, untuk membuat aplikasi desktop biasanya menggunakan Microsoft Access untuk databasenya.
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
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
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 RandNot the answer you're looking for? Browse other questions tagged ms-accesslibreoffice-base or ask your own question.
LibreOffice is a free suite of apps for creating text documents, spreadsheets, presentations, and more, which you can then save in Microsoft Office formats. With LibreOffice, you get nearly all the functionality of paid word processing and other programs without the hefty price tag.
Pros
Familiar interface: In LibreOffice, each program's interface will be familiar to anyone who's used Microsoft Office. Whether you're creating a presentation, a document, or a spreadsheet, you'll be able to quickly find the tools and features you're looking for, grouped just as you'd expect them to be.
Additional programs: In addition to the three core programs (Writer, Calc, and Impress), LibreOffice offers apps for drawing, math formulas, and databases. There is even a Database Wizard to guide you through the process of creating a new database.
Easy sharing: While the default file format for this program is ODT, you can save documents in several other formats. That includes Microsoft Office file formats, making it easy to share LibreOffice files with others. You can also open Microsoft Office files.
Cons
Convoluted help: LibreOffice's Help File contains very little information. There is also a Discussion page, presumably for users to exchange information and ask questions, but that is completely blank and doesn't allow you to enter anything.
Java Runtime Environment requirement: LibreOffice requires the latest version of Java Runtime Environment for certain features, including creating a new database. Without this extra installation, you won't be able to take full advantage of all program features.
Bottom Line
LibreOffice is a good alternative to Microsoft Word or other paid word processing programs and office suites. Its apps are accessible and organized in a familiar way, and the suite includes a few bonus apps. Power users will have to install Java Runtime Environment to get the most out of the program, but casual users can likely skip this step and just enjoy the basic functions of word processing, spreadsheet creation and management, and presentation construction -- all for free.