Base how does it work?

Discuss the database features

Base how does it work?

Postby dameous » Thu Aug 31, 2017 8:03 pm

Need help, just started on Base like yesterday. Went through videos after videos of how to build tables, forms, etc.

Question: So now that I've learned some basics what's next? I'm building the database for a small business where employees can access info and enter database of end customer and inventory but they shouldn't be able to see the background or be able to edit the background. How do I launch the forms into a format where my employees can fill the form only without editing? I'm building the tables and forms but can't seem to figure out how to make it live and employee facing....

I've worked on building websites where we publish it and users only see front end. But all the background is not visible.

Someone help? Or if I need to explain more please let me know and I'll try to explain it I guess.

openoffice 4.1.2 on windows 10
Posts: 1
Joined: Thu Aug 31, 2017 7:55 pm

Re: Base how does it work?

Postby Villeroy » Thu Aug 31, 2017 8:26 pm

Base is a tiny little extra to the office suite (15 MB including all drivers).
Since 7 years it is no longer under active development.
Its main purpose is to fill spreadsheets and text documents with data from various types of already existing databases, including pseudo-databases text files, address books and spreadsheets.
The vast majority of Base documents are created automatically to establish a mail merge connection from Writer to Calc.
Base is not a database development suite.

Since 2005 the "native Base database" (status bar reads "embedded HSQLDB") consists of a zip archive (the Base "document") which wraps text documents (the forms and reports) with some configuration data SQL strings (the queries) together with a 3rd-party HSQL database (outdated version 1.8). This "native" database is editable by a single, almighty user. It is not networkable. It is not safe. To the contrary, you will lose all your data sooner or later. It is very well suited for demos and for educational purposes. What it can do, it does way better than any spreadsheet based solution will ever do. Even with embedded HSQL, Base is not a full featured database development suite. Building a non-trivial relational database with Base requires a sound understanding of design concepts and some SQL knowledge. The GUI is incomplete and unstable.
Nevertheless, I use an ODF suite (OpenOffice or LibreOffice) together with a stand-alone HSQL server since many years with great success and zero problems for todo lists, work scheduling, inventory, cash book. My databases use almost no macro code, may be 10 or 20 lines.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Posts: 24969
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Base

Who is online

Users browsing this forum: No registered users and 8 guests