Open Legacy Files with OpenOffice.org
From time to time I will be adding items to these pages giving details of how to achieve certain objectives, usually related to genealogy and the use of Legacy software, often in conjunction with other software.
I am not suggesting that the solutions offered are the only, or indeed the best, options to solving problems but simply that they are ways which I have found to work.
* 'V' indicates a video is available
- Using Legacy Search V
- Search Events, Locations and Married Names V
- Create an Ancestry Book
- Map with Google Earth
- History of British Prime Ministers - Timeline
- British Civil Registration
- The Murder of Adam Mather
- Improve Photo Colour Balance
- Transparency with The Gimp
- Masking with The Gimp
- Web Safe Colours
- Create Legacy Web Pages - Part 1
- Create Legacy Web Pages - Part 2
- Create Legacy Web Pages - Part 3
- Using LTools Tidy Legacy HTML
- Insert Pictures into Web Pages
- Insert RSS Feed into Web Pages
- Getting Online
- Protect Your PC
- Open Legacy files with Open Office V
- FamGenContacts Database
- Create Direct Line Ancestor Tree
The icons below are links to any other software mentioned.
Open Legacy .fdb files with OpenOffice.org
Legacy's family file (".fdb") is an Access (".mdb") file and the first thing to do is to copy (NB. Always work on a copy) the file to a convenient place, say, My Documents and manually rename it from ".fdb" to ".mdb". You will see a warning about changing a file name but just ignore this, and click "OK".
To start the process of opening the file in Open Office, right click on the Open Office Logo on the task bar and select "Database". The screen shown on the right will appear then click the radio button "Connect to an existing database" and select "Microsoft Access" from the drop down menu. You may have to move the slider up as Access is the first on the list.
On the next screen browse to where you have put the now ".mdb" file and click the "Finish" button.
You will be asked to select a name for the file and it will have the extension ".odb" (I have used "Casual"). Click "Save" and the database will open.
The Data Base Opening Screen
The icons on the left of the screen are self explanatory and clicking on each will take you to that section. At present we just want to look at the files so click on "Tables" and we will see a list of the tables contained in the database. Double clicking any of the table names will open that table for inspection (and editing).
For the puposes of this article, one other function is of interest. The above screenshot shows the screen produced by Query>Use Wizard to Create Query.
Highlighting a column name on the left and then using the arrow to transfer it to the box on the right selects the fields to show and subsequent screens enable multiple sorts, searches and grouping.
For the safety of the data, it is strongly recommended that if changes to the file are made using OpenOffice.org, they are then copied back into a new ".fdb" file for use in Legacy. The name can always be changed when one is satisfied that the file is correct.Printer friendly version
Open Legacy Database in OpenOffice.org Video
Corrections, comments and suggestions are welcome, so please use the contact facility below.
The above information is given without warranty either expressed or implied