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

Hi :)
Ahh, i take it that "View" is the new name for "Queries"?  It is quite a
good name for it.  "Queries" had to be explained quite a bit although i
thought it made more sense tbh.

Open Source advocates and people who are helping organisations to move away
from Microsoft lock-ins often give the surprising advice of keeping the MS
systems in place!

This helps the migration flow more smoothly because some of the lock-ins
are difficult to escape.  By keeping the old system available people find
it easier to over-come some of the simpler hurdles without needing so much
extensive and intensive retraining.

Microsoft generally don't have a migration route for new products or newer
versions of products.  So people are forced into using the newer system.

Open Source generally encourages migration instead of using the typical
Microsoft route.  They/we usually allow you to keep the older system
alongside the newer one.  So normal users can keep going back to using the
older, more familiar tools when they really need to but tend to move to the
newer system because it's better and does more.  A few people need a bit of
a push so it's a good idea to set a deadline.

People often resent being forced into using the newer system.  For some
reason when the newer system is a Microsoft one it is often the user that
gets the blame or is made to look or feel like a foolish fuddy-duddy.  When
the newer system is anything other than Microsoft people are generally
encouraged to blame the software.

So, in this case i would keep the existing Access database and existing
copies of MS Office that are already installed.  LibreOffice works well
alongside MS Office.

Sometimes, at an early stage of migration, some newer machines need the
same version of MS Office to be installed but that fizzles out as more&more
works more smoothly on LibreOffice/OpenOffice
Regards from
Tom :)

On 13 August 2014 10:58, Alexander Thurgood <> wrote:

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

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.