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

Le 13/08/2014 10:55, Peter Goggin a écrit :

Hi Peter,

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
that SQL.

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
LibreOffice supports.

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.