[Solved] Edit address book database

[MrProgrammer]

A while ago I created an address book which I use in OO writer. It is an ODB file. Now I would like to edit some entries and add new ones. When I go into OO it brings up the ODB file and allows me to see it but not edit it. It has a screen called "Table Data View", but won't allow editing. When I use the Writer "Data Sources" (F4) I can also access the address book, but I can't make any changes. Any ideas?

Thanks,
AS

[MrProgrammer]

I can also access the address book, but I can't make any changes. Any ideas?

Registering an Address Book
In OpenOffice.org you can register different data sources. The contents of the data fields are then available to you for use in various fields and controls. Your system address book is such a data source.
OpenOffice.org templates and wizards use fields for the contents of the address book. When activated, the general fields in the templates are automatically replaced with the fields from the data source of your address book.
In order for the replacement to take place, you must tell OpenOffice.org which address book you use. The wizard asking for this information appears automatically the first time you activate, for example, a business letter template. You can also call the wizard by following the steps listed below.

The address book data is read-only in OpenOffice.org Base. It is not possible to add, edit, or delete address data from within Base.

[AsherRuchie]

Thanks. How can I edit the Address Book when people move etc. Is there another program that I can use if OO Base won't allow it???

[UnklDonald418]

You mention your data source is "Table Data View" which implies that your data source is a View. Views are actually a query disguised to look like a table and data supplied by a View cannot be edited using the View. Any edits would have to be to the data source supplying the View.
What did you use to create your address book?

[Villeroy]

[Tutorial] Read-Only in Base

[keme]

Thanks. How can I edit the Address Book when people move etc. Is there another program that I can use if OO Base won't allow it???

You may have Base connected to the Windows Contacts app. Then I guess you have to use that to edit your data.

[AsherRuchie]

I actually don't remember how I created the .odb file. Is there any way to find out? Any other way to create an editable file from my .odb file? This is quite frustrating!

[Villeroy]

The status bar of the database document indicates the connection type.

[UnklDonald418]

Any other way to create an editable file from my .odb file?

Yes, you can create a new table but any edits will only be to that table. The original data will not be affected.

First look in the lower left corner of your database window. If it says Enbedded database then you are good to go. If it says something else you may need to create a new Database to hold the new table.
From the database window click on the Tables tab and select and select “Table Data View”. Press <Ctrl>C to copy it to the clipboard and then <Ctrl>V to paste the clipboard contents. Note that if you had to create a new Database then paste into the Tables area of the new database instead of your original database.
A Copy Table dialog should be displayed.
Change the Table Name to something other than “Table Data View”
Under Options select “Definition and data”
Then click on the checkbox next to Create primary key and leave the default Name as “ID”
Next click on Create and a new table with the name you chose will be created and filled with the data from “Table Data View”.
The new table can now be edited, but remember the edits will only be saved into the new table you created.

[masterrrusty]

It seems as though you are saying here that ODB is not really a database per se. It is a "data reader" that allow you to view and utilize data from other sources. So therefore, if you want to edit the "data" you need to go to the "source" and edit it there.

So if I go back to the spreadsheet that I created an address book from and add a column a new data field will appear in ODB. Is that correct?

[UnklDonald418]

It is a "data reader" that allow you to view and utilize data from other sources. So therefore, if you want to edit the "data" you need to go to the "source" and edit it there.

Yes, Base is a front end for a database engine, for an Embeddded database its HSQLDB version 1.8 .

So if I go back to the spreadsheet that I created an address book from and add a column a new data field will appear in ODB. Is that correct?

No, you would need to use the process I described earlier to create a new table. Calc has no way of directly communicating any changes to the HSQLDB database engine.
However, Calc can use data supplied by the Base front end, as a Data source. When you press F4 on a Calc spreadsheet you will get a dialog that allows you to chose tables and queries from registered Base databases. Changes made to data in a database table can automatically show up on a spreadsheet, but, it doesn't work the other way around.

In an Embedded database everything is stored in the .obd file, which is actually a zip archive with the tables, queries, forms and reports all stored in a compressed format. If something goes wrong with the zip process, an .obd file can become corrupt and all the data is lost! So, when using an Embedded database, regular backups are extremely important.

[Villeroy]

A dBase connection is editable.

1) Create a dBase directory.
2) Save the spreadsheet as dBase (*.dbf) in that directory. This will only save the active sheet. Close the spreadsheet document.
3) Open your Base document, call menu:Edit>Database>Connection..., change the connection type from spreadsheet to dBase with the directory as source location. Each dbf file reporesents one database table. Of course you may create a new Base document for this connection but redirecting the spreadsheet connection preserves any queries, forms, reports and the database registration.

This connection does not provide full database functionality but the tables are editable in Base and in the data source window. dBase is much faster, particularly when you add indices. Dozends of applications can handle dBase files. You can store many millions of rows in one table.