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

On 7/30/16 8:40 AM, Harvey Nimmo wrote:
> 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!).

Thanks, Harvey.  Not the answer I was hoping for, but the one I 
expected.  LOL

Personally, I like the idea of the complete database package, as I think 
it makes it easier for the average person to create something useful for 
them.

> 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


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


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