Libreoffice base : can open mysql but not insert new record

Hello everybody,

I am using LibreOffice 3.5.7.2 with base to open mysql database (localhost). I am using ubuntu 12.04 .

Opening the database works fine but I cannot modify or add a new entry.

Thank you for your help,

Cheers,

Bertrand

Does you user have proper write permissions? Does your table have a primary key?

Hello,

Many thanks for your help.
The problem has been fixed by adding a primary key :
ALTER TABLE 'name of the table ’ ADD PRIMARY KEY (‘name of the variable’);

Cheers,

Bertrand