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.in...@gmail.com> wrote: From: drew jensen <drewjensen.in...@gmail.com> Subject: Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: documentat...@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+h...@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
