Re: [libreoffice-users] Re: Converting Microsoft Access to Libre Base

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 <alex.thurgood@gmail.com> 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.
>
>
> Alex
>
>
> --
> 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

-- 
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