On 01/20/2014 11:44 AM, Alex Thurgood wrote: > Le 20/01/2014 16:11, Mark LaPierre a écrit : > > 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_%28Base%29 > > 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. > >
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. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ **** -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
