Use Base as back end

users
#1

Hey Y'all,

Is it possible to link Libreoffice Base as a front end to tables in
another Libreoffice Base as a back end?

I'm trying to set up a recipe database where the tables are kept in a
Base back end. I don't want multiple versions of the recipe database
with different recipes in each located in each user's home. I want all
user front ends to share the same data.

I will not have more than ten users accessing the data.

If there is documentation that describes the process of connecting to a
Base back end please provide a URL for that.

I've looked at the documentation at:
https://wiki.documentfoundation.org/Documentation/Publications

but I can't find instructions for this type of connection.

#2

Hi Mark,

Is it possible to link Libreoffice Base as a front end to tables in
another Libreoffice Base as a back end?

Not that I know of, as the embedded hsqldb which is the default db
engine in an ODB file created with LO is mono-user by design.

What can be done, however :

https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=58337

https://wiki.openoffice.org/wiki/FAQ_(Base)

https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=17567

This enables you to have multi-user access to a hsqldb database via an
ODB file.

Alex

#3

It is not possible to do what I had envisioned due to the single user
paradigm of the built in hsqldb database. To pull it off you need to
install a local copy of the hsqldb database from this URL

http://sourceforge.net/projects/hsqldb/files/

Having done that you can then create a new Base front end linked to the
newly installed hsqldb hsqldb.jar file using the JDBC driver.

Once you have that done you can create tables to your heart's delight.
As long as you have the hsqldb database located in a directory that is
shared on the network you can access the tables from anywhere on the
network.