Page 1 of 1

Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 1:18 pm
by 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)

Re: Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 1:21 pm
by confusion0258
btw. The only key in my table to insert a record is greyed out

Re: Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 1:58 pm
by Villeroy
Your tables have primary keys which show a yellow key icon in table design or relation design?
Image

Re: Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 2:31 pm
by confusion0258
yes, it shows a primary key. And its only a single table without any relationships.

Re: Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 2:36 pm
by Villeroy
confusion0258 wrote:yes, it shows a primary key. And its only a single table without any relationships.

I'm clueless.

Re: Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 3:17 pm
by confusion0258
me neither :(
Anybody has any idea ?

Re: Unable to insert record to MS Access 2007 database

PostPosted: Fri Jan 07, 2011 6:20 pm
by 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...'

Re: Unable to insert record to MS Access 2007 database

PostPosted: Sat Jan 22, 2011 8:13 pm
by noviceuser
I am having the same problem. I cannot insert a new record. I can create a new form, etc.

Re: Unable to insert record to MS Access 2007 database

PostPosted: Sat Jan 22, 2011 8:14 pm
by Villeroy
noviceuser wrote: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

Re: Unable to insert record to MS Access 2007 database

PostPosted: Sat Jan 22, 2011 8:58 pm
by 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".

Re: Unable to insert record to MS Access 2007 database

PostPosted: Sun Jan 23, 2011 6:55 pm
by 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.

Re: Unable to insert record to MS Access 2007 database

PostPosted: Sun Jan 23, 2011 7:36 pm
by 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