Unable to insert record to MS Access 2007 database

Discuss the database features

Unable to insert record to MS Access 2007 database

Postby confusion0258 » Fri Jan 07, 2011 1:18 pm

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)
OpenOffice 3.2 on Windows 7
confusion0258
 
Posts: 4
Joined: Fri Jan 07, 2011 1:12 pm

Re: Unable to insert record to MS Access 2007 database

Postby confusion0258 » Fri Jan 07, 2011 1:21 pm

btw. The only key in my table to insert a record is greyed out
OpenOffice 3.2 on Windows 7
confusion0258
 
Posts: 4
Joined: Fri Jan 07, 2011 1:12 pm

Re: Unable to insert record to MS Access 2007 database

Postby Villeroy » Fri Jan 07, 2011 1:58 pm

Your tables have primary keys which show a yellow key icon in table design or relation design?
Image
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to insert record to MS Access 2007 database

Postby confusion0258 » Fri Jan 07, 2011 2:31 pm

yes, it shows a primary key. And its only a single table without any relationships.
OpenOffice 3.2 on Windows 7
confusion0258
 
Posts: 4
Joined: Fri Jan 07, 2011 1:12 pm

Re: Unable to insert record to MS Access 2007 database

Postby Villeroy » Fri Jan 07, 2011 2:36 pm

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

I'm clueless.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to insert record to MS Access 2007 database

Postby confusion0258 » Fri Jan 07, 2011 3:17 pm

me neither :(
Anybody has any idea ?
OpenOffice 3.2 on Windows 7
confusion0258
 
Posts: 4
Joined: Fri Jan 07, 2011 1:12 pm

Re: Unable to insert record to MS Access 2007 database

Postby eremmel » Fri Jan 07, 2011 6:20 pm

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...'
It's Microsoft marketing that tells you computers are qualified for non-technicians
eremmel
 
Posts: 1040
Joined: Tue Dec 30, 2008 1:15 am

Re: Unable to insert record to MS Access 2007 database

Postby noviceuser » Sat Jan 22, 2011 8:13 pm

I am having the same problem. I cannot insert a new record. I can create a new form, etc.
Open Office 3.2 on Vista Ultimate
noviceuser
 
Posts: 3
Joined: Sat Jan 22, 2011 8:04 pm

Re: Unable to insert record to MS Access 2007 database

Postby Villeroy » Sat Jan 22, 2011 8:14 pm

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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to insert record to MS Access 2007 database

Postby noviceuser » Sat Jan 22, 2011 8:58 pm

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".
Open Office 3.2 on Vista Ultimate
noviceuser
 
Posts: 3
Joined: Sat Jan 22, 2011 8:04 pm

Re: Unable to insert record to MS Access 2007 database

Postby noviceuser » Sun Jan 23, 2011 6:55 pm

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.
Open Office 3.2 on Vista Ultimate
noviceuser
 
Posts: 3
Joined: Sat Jan 22, 2011 8:04 pm

Re: Unable to insert record to MS Access 2007 database

Postby r4zoli » Sun Jan 23, 2011 7:36 pm

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
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary


Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests