Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Juergen]

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
>>  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
>> 

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Jenny M Benson]

On 09/02/2016 11:44, 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)

Much the same as you would answer a private e-mail.  When viewing the
post to which you want to respond, select "Reply" or "Follow-up" or
whatever your e-mail client calls it.

--
Jenny M Benson




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

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Gerald E Boor]

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 
 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

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Evert van Dijken]

Did you have a look at LTools? I think you can run your own queries in
Ltools to update the legacy database. The Deluxe version is free now.
http://zippersoftware.com/wp/ltools/what-is-ltools/
Evert

2016-02-09 12:44 GMT+01:00 Colin Charman :

> 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

[LegacyUG] Accessing the Legacy fdb file from Open Office

[Colin Charman]

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

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Gene Young]

On 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)

Send a new Email to legacyusergroup@LegacyUsers.com with the subject of your 
choice.

> 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?

Try MDBViewer plus (Freeware) from http://www.alexnolan.net/.  It may fit your 
needs.


--

Gene Young
Researching Young, Harer, Cox & Sallada
With Legacy Family Tree
http://myyoungs.atspace.com/index.htm




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

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Hannigan Family Research]

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
<>

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Cathy Pinner]

Colin

A subscription to Office 365 in Australia costs $119 AUD each year.
Cheaper than buying Office Professional and keeping it anywhere near up
to date - especially since you can run it on multiple devices.
I've had a subscription for at least 2 years now.

I tried Open Office for a short while but found it a frustrating
experience. I guess I was a power user of Word at the time.

Cathy

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,
> 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
>>  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

Re: [LegacyUG] Accessing the Legacy fdb file from Open Office

[Colin Charman]

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
>  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:
>