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


On Fri, 2016-07-29 at 20:53 -0600, Ken Springer wrote:
The subject says it all, how successful is Base in importing Access 
Databases?

LO 5.0.x

-- 
Ken
Mac OS X 10.8.5
Firefox 44.0
Thunderbird 38.0.1
"My brain is like lightning, a quick flash
      and it's gone!"


Unfortunately, MS Access users were spoilt with the 'complete' database
package supporting tables, queries, forms, reports and modules/macros.
Although its 'openness' or performance or compatibility with the rest
of the MS Office suite leave much to be desired (in my humble opinion)
the MSaccess package is a (more or less) complete solution. LibreOffice
on the other hand cannot match the user comfort (yet!).

There is a tool, access2sql that to allows you to generate the sql
needed to build all your 'tables' again (including their data) and
'queries'. But for the 'forms' and 'reports' you will have to start
from scratch in LOBase and, as I say, the user comfort for that is not
as mature as in MSAccess. In LOBase you can also write modules/macros
in Visual Basic. I have no experience of that either, but it does
suggest that VBA macros might with reservation be portable and
modifiable.

In other words, i blieve it is not hopelessly impossible and
I am sure that the experts can add their 'two penn'orth'

Cheers
Harvey




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

Context


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.