Yes its quite expensive to buy MS Office Professional. I think MS want to change their customer base over to Office365 - their rentals scheme. It would cost roughly the amount you mentioned for one PC - but they also have a rental plan that covers up to 5 devices, which I'd need to cover my desktop and laptop. They have to make a living somehow and having millions of Office2000 users doesnt contribute anything!
I think the most likely route might be Libre Office - the successor to Open Office. I've read something that suggests there may be VBA support with their version of Base (Access), but I couldnt get Libre to open an Access database today when I tried. I'm playing with railway engines tomorrow so I'll have another look at LibreOffice later on. Regards, Regards, Colin Charman On 09/02/2016 14:50, Gerald E Boor wrote: > > Colin, it's amazing to me that getting Microsoft Access in the UK > would be that expensive. But for awhile, I rented the complete > Microsoft Office Suite, which included Word, Excel, PowerPoint and > Access for $6.99per month, U.S. dollars. Just go to the Microsoft > Office website and see what their current offerings are. It allowed me > to download the entire suite, but when I decided to migrate to MySQL > and to save money, I gave it up. It is still on my desktop, but > because I am no longer a subscriber, it is READ ONLY. Food for > thought, but SQLmight also do what you require. Jerry Boor, > MerriamFamilyTree.org > > On February 9, 2016, at 08:29, Hannigan Family Research > <[email protected]> wrote: > > >Colin, > >Have you tried LibreOffice? Their Access component is also called > 'Base' and can be downloaded at www.libreoffice.org. > >John > > > > > >On Tuesday 2 9 2016 6:44 AM, Colin Charman wrote: > > > >This should probably be in the Tools Utilities thread, but as Ive > only just joined this group after using Legacy for 20+ years, I cant > figure out how to post into a thread! (any clues welcome) > >I'm doing a one-name study and thus I have several hundred people in > my file called "William Charman" - Legacy isnt too much help in > locating the right one so Ive written numerous MS Access queries that > just help me find the right one amongst many similarly named > individuals - that kind of thing. > >Ive also occasionally (and very very carefully) used MS Access to > update the fbd file - I grew up in IT so I know about backups, > testing, etc. > >For some years Ive wondered about using an alternative to Microsoft > Access. I'm still using Access 2000 and to purchase a modern > equivalent is really quite expensive - about $400-$500 here in UK. > Ive tried Open Office but can't see a way to link to the Legacy .fdb > file. I know I can set up an .mdb file containing links to the .fdb > file, and Open Office can open that as a kind of surrogate. Has > anyone found a way of opening or making a link to an .fdb file in Open > Office? > >Even if this were possible, there is another problem in interpreting > Legacy dates. In MS Access I have a home written VBA function which > turns the 18-byte legacy date into a readable format. As far as I > know, Open Office supports some kind of VBA in its equivalent of Word, > Excel and Powerpoint - but I cant find it in Base (its equivalent of > Access). Does anyone here know whether Open Office or its > relatives can run VBA? > >And lastly, are there any (free!) alternatives to MS-Access or > OpenOffice that might do the trick? > > > >Legacy User Group guidelines: > >http://www.LegacyFamilyTree.com/Etiquette.asp > >Archived messages after Nov. 21 2009: > >http://www.mail-archive.com/[email protected]/ > >Archived messages from old mail server - before Nov. 21 2009: > >http://www.mail-archive.com/[email protected]/ > >Online technical support: http://support.legacyfamilytree.com > >Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) > and on our blog (http://news.LegacyFamilyTree.com). > >To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > >Legacy User Group guidelines: > >http://www.LegacyFamilyTree.com/Etiquette.asp > >Archived messages after Nov. 21 2009: > >http://www.mail-archive.com/[email protected]/ > >Archived messages from old mail server - before Nov. 21 2009: > >http://www.mail-archive.com/[email protected]/ > >Online technical support: http://support.legacyfamilytree.com > >Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) > and on our blog (http://news.LegacyFamilyTree.com). > >To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Online technical support: http://support.legacyfamilytree.com > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) > and on our blog (http://news.LegacyFamilyTree.com). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com> > Version: 2016.0.7357 / Virus Database: 4530/11589 - Release Date: 02/09/16 > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp

