Thanks! Works a treat.
Brenda.
Yes I think it belongs here since it is how to use Legacy with other
programs.
How to access the database with OpenOffice.
1) COPY the LEGACY DATA BASE TO a NEW directory!!!!!!!!
2) Check that the version of OpenOffice (OO) is at least 1.1
3) Read the instructions on this link for how to add a datasource.
http://dba.openoffice.org/FAQ/FAQ.html#msaccess
Check that you have the MDAC installed
I have copied the data base to c:\Temp\Test\Westberg.fdb so my data
source URL look like this.
PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=c:\Temp\Test\Westberg.fdb
4) Start OO spreadshit.
5) Open tools->datasources
6) Click on New Datasource
7) Set the databsetype to ADO
8) Edit the datasource URL to something similar to my in 3.
9) Click on Apply
10) you can no look at the table definitions in tables tab
11) Click on ok.
12) Go to View -> datasources
13) Select the datasource and expand the tables.
14) Have fun and do not blame me if you can read back the database in
Legacy.
sow/
At 09:23 AM 12/24/03 +1300, Gary & Brenda Anderson wrote:
Hi,
I"ve got openoffice but haven't figured out how to open the legacy
database. Can you post instructions (privately if it's considered
off-topic). Thanks!!
Brenda Anderson
Masterton, New Zealand.
([EMAIL PROTECTED])
Hi.
I just want ro report that it is possible to access the legacy
database from the free OpenOffice1.1. No need to buy access.
With openoffice it is easy to import a table to the spreadsheet.
sow/
--
Brenda Anderson
Masterton, New Zealand
([EMAIL PROTECTED])
Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
