Faq/Base/005

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

I can access my table through LibreOffice, but I can't insert or edit any data, it seems to be read only.

LibreOffice requires the table (or, more generally, data in a database) to contain a primary key to allow data editing. Some drivers, on a table that has no primary key but has a unique index, will advertise a unique index as primary key, which means that LibreOffice will allow data editing.

Alternatively, it is enough that the driver supports bookmarks [that doesn't sound right] (as certain ODBC drivers do, or the basic dBase implementation).

The reason for this requirement is that it is the only certain way to ensure that your changes are recorded correctly (in the case of editing) in order to be able to work on your new data later.