Hi 
If possible it is a good idea to export your database tables to a different
program such as Postgresql or MariaDb/MySql or any other non-Java external
"back-end". Then hopefully Base can connect to your external back-end
without having to edit your Queries, Forms or Reports much.
This is a good start to "up-scaling" your database so that the data can be
used in other ways and/or by other programs and maybe even on other
machines.
Base's internal back-end is not great and is worth moving away from. It
was only plugged in to make Base behave more like MS's very limiting
"Access" program instead of using Base the much more powerful way it was
initially designed to be used.
Regards from
Tom
Dear sirs!
I have a problem with using of LibreOffice Base because of message about
non-working Java in my system.
Although Java is installed in my system.
My OS is Windows XP SP3 32-bit on my netbook Asus Aspire One D270k, and
i tried versions JRE-7u79 and JRE-6u45, and also latest Java 8 (although
officially Java 8 is not support Windows XP), and in all cases when i work
with LibreOffice Base document and try to open sheet, i have a message that
JRE is corrupted. Reinstalling of Java and LibreOffice does not give any
positive effect.
I also tried to install Java in directory with installed LibreOffice, it
also didn't give positive effect.
I use latest LibreOffice_4.4.3_Win_x86 version.
Troubleshooting Open/LibreOffice and Java
https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=69896
--
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
On 05/27/15 09:47, Tom Davies wrote:> Hi
If possible it is a good idea to export your database tables to a
different
program such as Postgresql or MariaDb/MySql or any other non-Java external
"back-end". Then hopefully Base can connect to your external back-end
without having to edit your Queries, Forms or Reports much.
This is a good start to "up-scaling" your database so that the data can be
used in other ways and/or by other programs and maybe even on other
machines.
Base's internal back-end is not great and is worth moving away from. It
was only plugged in to make Base behave more like MS's very limiting
"Access" program instead of using Base the much more powerful way it was
initially designed to be used.
Regards from
Tom
Hey Tom,
It is possible to place your data in MySQL, MariaDB, or other database
backends. Base can link to tables in MySQL. I've done it, but not very
well, a couple of times. Seems I've got a lot to learn.
You can also link to tables maintained by a stand alone version of the
same built in database that Base uses. I've done that too, but not very
well. It's called HSQLDB. You can set up an instance on a server and
connect to it over your network, or you can set up an instance on the
same computer and connect to it directly.
![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}