Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.