Re: [libreoffice-users] compatibility with Microsoft Access

Hi :)
Yes, sadly SQL is not as standardised as was originally envisaged.
Each different application add their own range of extra features or
short-cuts or find some "better way" of doing particular instructions.

It's quite different from "ODF 1.2 Extended" where each different
program tends to have exactly identical versions of the "Extended" and
only a few try out a few different ways of doing things.  Also
programs that use ODF tend to have an option to choose to use the more
standard ODF 1.2 or even go back to the ISO standard ODF 1.1/1.0.
Plus when using ODF 1.2 Extended for a specific document and then open
that document in a program that only has ODF 1.0 the document is still
handled fairly properly.

By contrast Sql is a completely messy nightmare.  Access does do a
particularly impressive job of being pretty much the least compatible
with anything else - even being fairly incompatible with other MS
database programs.


Access has other problems such as not having any separation between
the way database-designers or builders see it and the way normal
office workers see it.  So normal office workers are often slightly
petrified of using databases because they often find themselves
suddenly dropped into design views and stuffing the whole thing up by
accident.

It does allow Forms and Reports to try to protect normal users from
being exposed to tooo much complexity but those are only viewable in
the entirely unfamiliar Access User-Interface and all the buttons and
such could easily be completely non-standard compared to the way the
rest of the OS operates and may even be broken or become broken over
time.

Access is not like Base where look-up Forms Reports can be created in
Writer or Calc allowing the office workers to stay in familiar User
Interfaces and safely away from anything to do with design elements.


To me it's always been quite shocking that Base is marketed as being
the equivalent of or a suitable replacement for Access.  Base, even as
it is at the moment, is sooo much more advanced than Access could ever
hope to be.

Regards from
Tom :)




On 29 January 2015 at 16:48, jomali <jomali3945@gmail.com> wrote:
> It depends on what you mean by "coding" and what the requirements of the
> course are. If she is to be coding in VBA, only Access will do. If she will
> be required to use Access on tests, only Access wil do. Even the SQL that
> Access uses has some differences from the SQL used in Base, since Base does
> not use the Jet engine that Access uses. The reporting system in Access is
> quite unique, and learning the Libreoffice equivalents would be confusing
> to a beginner.
>
> So, sadly, it looks like you'll have to use Access.
>
> On Thu, Jan 29, 2015 at 8:45 AM, lalitadatta <lalitadatta1993@gmail.com>
> wrote:
>
> > Hi,
> > My daughter's in need of Microsoft access for her homework - she's studying
> > computer
> > technology at high school, and she needs Access for coding.  Anyone knows
> > if
> > liber office should do the job?
> > Thanks in advance.
> >
> >
> >
> > --
> > View this message in context:
> > http://nabble.documentfoundation.org/compatibility-with-Microsoft-Access-tp4138053.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> > --
> > 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

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