I had no problems opening the .fdb Legacy file in LibreOffice 5.0 if you change the extension from .fdb to .mdb . Then Libre Office makes a .odb file that connects to the .mdb file. I don't believe LibreOffice uses the VBA macros but has their own LibreOffice API.
On 2/9/2016 11:30 AM, Colin Charman wrote: > 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 >> <resea...@hannigangenealogy.us> 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/legacyusergroup@legacyusers.com/ >> >Archived messages from old mail server - before Nov. 21 2009: >> >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ >> >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/legacyusergroup@legacyusers.com/ >> >Archived messages from old mail server - before Nov. 21 2009: >> >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ >> >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/legacyusergroup@legacyusers.com/ >> Archived messages from old mail server - before Nov. 21 2009: >> http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ >> 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/legacyusergroup@legacyusers.com/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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