Re: [libreoffice-users] Compatibility of LO Base with Access databases

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