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.99 per 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 SQL might 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
