[libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

Hi :)
Ok, so when migrating from Access to Base would it be best to first export the Access tables into a 
different database program and then get Access to read those tables?  

Would that mean re-writing Access's Reports and Forms that are based on the tables?
Regards from
Tom :)


--- On Wed, 14/3/12, drew jensen <drewjensen.inbox@gmail.com> wrote:

From: drew jensen <drewjensen.inbox@gmail.com>
Subject: Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
To: documentation@global.libreoffice.org
Date: Wednesday, 14 March, 2012, 2:18

On Tue, 2012-03-13 at 09:16 -0300, Lailah wrote:
> Tom:
>              I agree with you but I can't see what is the of mentioning Access. I mean, we know 
> that Access works in an specific way and Base work in others, but I don't we have to mention it in 
> the documentation.
> I think that saying  is a replacement for others database front-ends is enough.  No need of 
> mentioning any other name.  And no need of saying that is ugly and that other is pretty.
> We only have to describe our application, that's all.
> What do is important is to say is  "this is better because..."  and describe why is flexible, 
> easy to use, etc.

Well, the ability to work with MS Access is a highly important question and one that if you are 
being truthful is not really possible with Base.

You can connect to an Access Database as a data source, but you are not able to make much if any 
use of major parts of the data (beyond the tables) held in the MS Access file.

There are also a number of very difficult situations with MS Access that are commonly the downfall 
of attempting actual interoperability.

Some of the things that the manual should point out, IMO, queries will be viewed in Base as either 
tables or views - this means that users are often befuddled as to why some Access table will not 
take updates - cause they aren't tables, kids.

Queries in MS Access support features for which there are NO equivalents in Base, without resorting 
to scripting.

Forms in MS Access support features for which there are NO equivalents in Base, and you likely 
would need C++ code to duplicate those, forget the scripting.

The same can be said for reports.

MS Access supports the ability to connect to multiple data sources,
another 'feature' for which there is NO equivalent in Base or LibreOffice for that matter. (Two 
data sources on a stand alone form are not the same thing)

[However, this actually does have a work around - you simply must use a DB backend that can do this 
instead]


Anyway - I would, if I where actually doing this and so I it's my call,
include some information about the issue with queries being picked up as 'views' as this bites a 
lot of people..beyond that, it's likely FAQ type stuff, IMO.

Best wishes

//drew



-- 
For unsubscribe instructions e-mail to: users+help@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