Unable to insert record to MS Access 2007 database
-
- Posts: 4
- Joined: Fri Jan 07, 2011 1:12 pm
Unable to insert record to MS Access 2007 database
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)
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
-
- Posts: 4
- Joined: Fri Jan 07, 2011 1:12 pm
Re: Unable to insert record to MS Access 2007 database
btw. The only key in my table to insert a record is greyed out
OpenOffice 3.2 on Windows 7
Re: Unable to insert record to MS Access 2007 database
Your tables have primary keys which show a yellow key icon in table design or relation design?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 4
- Joined: Fri Jan 07, 2011 1:12 pm
Re: Unable to insert record to MS Access 2007 database
yes, it shows a primary key. And its only a single table without any relationships.
OpenOffice 3.2 on Windows 7
Re: Unable to insert record to MS Access 2007 database
I'm clueless.confusion0258 wrote:yes, it shows a primary key. And its only a single table without any relationships.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 4
- Joined: Fri Jan 07, 2011 1:12 pm
Re: Unable to insert record to MS Access 2007 database
me neither
Anybody has any idea ?
Anybody has any idea ?
OpenOffice 3.2 on Windows 7
Re: Unable to insert record to MS Access 2007 database
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...'
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
W11 22H2 (build 22621), LO 7.4.2.3(x64)
W11 22H2 (build 22621), LO 7.4.2.3(x64)
-
- Posts: 3
- Joined: Sat Jan 22, 2011 8:04 pm
Re: Unable to insert record to MS Access 2007 database
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
Re: Unable to insert record to MS Access 2007 database
And nobody can help you with no informationnoviceuser wrote:I am having the same problem. I cannot insert a new record. I can create a new form, etc.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 3
- Joined: Sat Jan 22, 2011 8:04 pm
Re: Unable to insert record to MS Access 2007 database
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
-
- Posts: 3
- Joined: Sat Jan 22, 2011 8:04 pm
Re: Unable to insert record to MS Access 2007 database
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
Re: Unable to insert record to MS Access 2007 database
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
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
Hungarian forum co-admin