Le 13/08/2014 10:55, Peter Goggin a écrit :
I cannot see how to transfer rhe MS Access to run uder LibreBase. I
tried doing the conversion under XP by loading LibreOffice and then
opening the Access data base using LibreBase. with the following results:
All this does unfortunately, is link your ODB file to the MDB data source.
1 All tables were successfully converted and retained their data.
2 All vies finished as being defined as tables.
Yes, generally tables and views are converted to tables.
3 No forms were transferred.
Forms, Queries and Reports have to be rebuilt.
Is there an easy way to convert Access data bases to run under LibreBase?
No, not without redoing much of the work that you did in Access to make
your db work for you in the way you wanted.
Can I get the vies transferred as vies ? Do I need to extract the SQL
for the vies and then recreate them in Libre Base.
Export the View as SQL, and then create a new view in LibreOffice with
If I cannot transfer the forms directly then I will need to recreate
them. I have looked at how forms work in LibreBase butr I cannot find
out how to create a menu form which allows the juser to select other
menu forms or data entry forms.
For that, you should try installing the Switchboard extension
(LibreOffice extensions website), to see if it meets your needs, or else
learn to manipulate UNO objects via one of the scripting languages that
Is there a reort system in Libre Base?
Yes, it is called ReportBuilder, and is a Java-based subset of the
Pentaho reporting engine. You need a JVM/JRE in order to use it, and by
default on current Ubuntu installations, it is not installed (neither is
Base for that matter) with the default installation of LibreOffice.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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