Unable to insert record to MS Access 2007 database

[confusion0258]

HI all,

I'm running OpenOffice Base version 3.2. I;m connecting to a MS Access 2007 database.

The problem is I can't add any records It seems to be the database is in readonlymode

My table does have a primary key.

I searched for 2 hours, but found no solution. It must be possible to edit my ACCDB format database right?

Flame icon removed. That icon means 'Tagged to a known issue' (TheGurkha, Moderator)

[confusion0258]

btw. The only key in my table to insert a record is greyed out

[Villeroy]

Your tables have primary keys which show a yellow key icon in table design or relation design?

[confusion0258]

yes, it shows a primary key. And its only a single table without any relationships.

[Villeroy]

yes, it shows a primary key. And its only a single table without any relationships.

I'm clueless.

[confusion0258]

me neither
Anybody has any idea ?

[eremmel]

Might it have to do with the way you are connected? (see status line in Base Window). I think there are two options: msaccess and ODBC. You might try the other one.
Can you add data when you use direct plain SQL? Try to enter an insert/update statement via Tools -> 'SQL...'

[noviceuser]

I am having the same problem. I cannot insert a new record. I can create a new form, etc.

[Villeroy]

I am having the same problem. I cannot insert a new record. I can create a new form, etc.

And nobody can help you with no information

[noviceuser]

The data base was created using Access 2007. The data base has no relationships. It is very simple entry of multiple fields of data for a specific item. The data base was opened in Open Office by performing the the following steps: OpenOffice>database>connect to existing database (in dropdown menu Microsoft Access 2007)>next>database file selected via browser (File Name: "Name".accdb)>open>next>(register database checked and open database for editing checked)>finish. Save As panel opens clicked on Save and file opens. A record can be deleted but the option to insert a record is "greyed out".

[noviceuser]

I opened the Access 2007 database, the same database that Open Office could not insert records into, using MS Access and saved the database in an Access 2000 format. The Access 2000 database was then accessed using OpenOffice. The Access 2000 database opened in OO CAN be edited and records CAN be inserted. I would not call this a solution but this technique can be used as a "work-around". Apparently, Access 2007 databases cannot be manipulated in OO.

[r4zoli]

I tested on win7 with Northwind 2007 accdb sample file, created odb file.
I could not add to, for example, "Order" table any data, but it has a PK.
I submitted a bug: http://qa.openoffice.org/issues/show_bug.cgi?id=116577