Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
Hi :) So Base can't update Accesses internal tables? Regards from Tom :) --- On Wed, 14/3/12, drew jensen drewjensen.in...@gmail.com wrote: From: drew jensen drewjensen.in...@gmail.com Subject: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: documentat...@global.libreoffice.org Cc: users@global.libreoffice.org Date: Wednesday, 14 March, 2012, 12:27 On Wed, 2012-03-14 at 11:59 +, Tom Davies wrote: 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? No. I referred to situations where Base is updating ms-jet or accdb (MS Access data engines) directly. Would that mean re-writing Access's Reports and Forms that are based on the tables? Regards from Correct - there is no way to re-use any of those. 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 -- 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
Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote: Hi :) So Base can't update Accesses internal tables? That is NOT what I said. What I said was, that when connecting to an MS Access file the users need to be mindful of the fact that queries in the Access file will appear to them to be tables or views in the Base interface. //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
Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
Hi :) Ahhhah. Right. Ok, so it sounds as though i could at least give it a go and see what it looks like. So far i have been a bit scared of even trying. So, first step for me is to back-up the Access file and see if i can get Base working with that. The Access we have at work is a mess of too many Queries let alone tons of Forms and Reports that no-one uses. It's just a huge pile of confusing mess. It would be good to start again with Base but everyone is extremely paranoid about the whole thing. We don't understand it so don't touch Many thanks and 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-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: users@global.libreoffice.org Date: Wednesday, 14 March, 2012, 12:57 On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote: Hi :) So Base can't update Accesses internal tables? That is NOT what I said. What I said was, that when connecting to an MS Access file the users need to be mindful of the fact that queries in the Access file will appear to them to be tables or views in the Base interface. //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 -- 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
Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
On Wed, 2012-03-14 at 13:12 +, Tom Davies wrote: Hi :) Ahhhah. Right. Ok, so it sounds as though i could at least give it a go and see what it looks like. So far i have been a bit scared of even trying. So, first step for me is to back-up the Access file and see if i can get Base working with that. The Access we have at work is a mess of too many Queries let alone tons of Forms and Reports that no-one uses. It's just a huge pile of confusing mess. It would be good to start again with Base but everyone is extremely paranoid about the whole thing. We don't understand it so don't touch Many thanks and regards from Ok but keep in mind that the same people that made that pile of mess are likely the ones to make the next pile of mess - in other words it may not be the technology that needs changing. Tom :) --- On Wed, 14/3/12, drew jensen drewjensen.in...@gmail.com wrote: From: drew jensen drewjensen.in...@gmail.com Subject: Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: users@global.libreoffice.org Date: Wednesday, 14 March, 2012, 12:57 On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote: Hi :) So Base can't update Accesses internal tables? That is NOT what I said. What I said was, that when connecting to an MS Access file the users need to be mindful of the fact that queries in the Access file will appear to them to be tables or views in the Base interface. //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 -- 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
Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
Hi :) They all left. The people that are using the system are not the ones that set it up. I think part of the idea was that we would have to pay the previous people a consultancy fee in order to do fairly normal stuff. Now it's my turn to create even more confusion by creating forms that are called things relevant to what they do. In our Access forms we have 1 called Organisations-~ and the one thing i can guarantee it doesn't show is anything to do with any organisation. lol 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-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: users@global.libreoffice.org Date: Wednesday, 14 March, 2012, 13:16 On Wed, 2012-03-14 at 13:12 +, Tom Davies wrote: Hi :) Ahhhah. Right. Ok, so it sounds as though i could at least give it a go and see what it looks like. So far i have been a bit scared of even trying. So, first step for me is to back-up the Access file and see if i can get Base working with that. The Access we have at work is a mess of too many Queries let alone tons of Forms and Reports that no-one uses. It's just a huge pile of confusing mess. It would be good to start again with Base but everyone is extremely paranoid about the whole thing. We don't understand it so don't touch Many thanks and regards from Ok but keep in mind that the same people that made that pile of mess are likely the ones to make the next pile of mess - in other words it may not be the technology that needs changing. Tom :) --- On Wed, 14/3/12, drew jensen drewjensen.in...@gmail.com wrote: From: drew jensen drewjensen.in...@gmail.com Subject: Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: users@global.libreoffice.org Date: Wednesday, 14 March, 2012, 12:57 On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote: Hi :) So Base can't update Accesses internal tables? That is NOT what I said. What I said was, that when connecting to an MS Access file the users need to be mindful of the fact that queries in the Access file will appear to them to be tables or views in the Base interface. //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 -- 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 -- 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