#Where openoffice databases stored password#

This is discussed in Chapter 11 (Using Mail Merge) in the Writer Guide. Selecting Tools > Mail Merge Wizard or clicking on the Mail Merge icon (a small paper-and-envelope icon on the View Data Source pane) launches the Mail Merge wizard which steps through creating a mail merge document. Now double-click on a table to see all the records held in it. Click on the + next to Tables to view the individual tables created. (This has been done for the Automobile database shown below.) This brings up Tables and Queries.

To view each database, click on the + to the left of the database's name. This brings up a list of registered databases, which will include Bibliography and any other database registered. To view the data sources available, press F4 or select View > Data Sources from the pull-down menu. Having registered the data source, whether a spreadsheet, text document, external database or other accepted data source, you can use it in other components including Writer and Calc.

Make sure the registered name is correct.

Browse to where the database is located.

To register a database created by OOo2.x or later: Below this list are three buttons: New, Delete, Edit. Under Registered databases, there is a list of these databases. Top of page Registering databases created by OOo2.x or later This method only allows you to view the contents of the spreadsheet, run queries, and create reports based upon the data already entered into the spreadsheet. All modifications must be made in the spreadsheet itself. This method of accessing a spreadsheet does not allow you to change anything in the spreadsheet.

#Where openoffice databases stored password#

If a password is also required, check its box. If the spreadsheet requires a user's name, enter it.

If the spreadsheet is password protected, check the Password required box. Click Browse to locate the spreadsheet you want to access.Select Connect to an existing database.These are steps 1, 2 and 4 of Accessing a dBase database.Īccessing a spreadsheet is also very similar to accessing a dBase database. Select Mozilla Address Book as the database type. Top of page Accessing a Mozilla address bookĪccessing a Mozilla Address Book is very similar to accessing a dBase database. Create the Form using the Form Wizard as explained in Creating a database form.Name and save the database in the location of your choice. Accept the default settings: Register the database for me, and Open the database for editing.Click Browse and select the folder containing the database.