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

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