Ask Your Question

access 2010 [closed]

asked 2012-07-26 15:41:56 +0200

Emilio71 gravatar image

updated 2015-10-17 15:08:55 +0200

Alex Kemp gravatar image

Hi. I am trying to migrate from Access 2010 to Libre Office Base. I have set up a connection to my Access file and LibO opens it fine. Only problem is I can not ADD or modify any record...

any clue?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 15:07:54.150646


Mariosv, I saw your answer. Unfortunately, the table already has a primary key in Access and when I connect my Libo file to the original file it detects correctly the primary key.

...still no way to add a record...

Emilio71 gravatar imageEmilio71 ( 2012-08-04 14:57:25 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-08-04 15:59:32 +0200

Emilio71 gravatar image

I found out that the problem lies in the fact that LibO deals with ACCESS 2007 files. Access 2010 files are slighly different and MS Access blocs editing of 2010 files if they are opened as 2007 files.

See this:

Unfortunately, contrary to the quoted thread ( I don't have non supported features and even making a new database with a very simple table can't edit it.

Solution? LibO, PLEASE add Access 2010 files support!!!!!

edit flag offensive delete link more


If can set a ODBC connection in your system to your access 2010 database, I think there is no problem to use an ODBC connection in Base. Or ask to MS about clean artificial blocks. I think only to obligate people to update.

m.a.riosv gravatar imagem.a.riosv ( 2012-08-04 16:10:27 +0200 )edit

Hi @Emilio71, Take a look at this entry: LO 3.6 might have better support. If you still have issues with the file format, please file an enhancement bug. Thanks!

qubit gravatar imagequbit ( 2013-01-29 10:40:30 +0200 )edit

answered 2012-07-26 23:52:55 +0200

m.a.riosv gravatar image

updated 2012-07-26 23:55:25 +0200

LibreOffice help:

Table Design

This section contains information about how to create a new database table in the design view. Open the database file of the database where you want a new table. Click the Tables icon. Choose Create Table in Design View to create a new table. In the Design view, you can now create the fields for your table. Enter new fields in rows from top to bottom. Click the Field Name cell and enter a field name for each data field.

Include a "primary key" data field. Base needs a primary key to be able to edit the table contents. A primary key has unique contents for each data record. For example, insert a numerical field, right-click the first column, and choose Primary Key from the context menu. Set AutoValue to "Yes", so Base can automatically increment the value for each new record. In the next cell to the right, define the Field Type. When you click in the cell, you can select a field type in the combo box.

Each field can only accept data corresponding to the specified field type. For example, it is not possible to enter text in a number field. Memo fields in dBASE III format are references to internally-managed text files which can hold up to 64KB text.

You can enter an optional Description for each field. The text of the description will appear as a tip on the column headings in the table view.

edit flag offensive delete link more

Question Tools


Asked: 2012-07-26 15:41:56 +0200

Seen: 1,817 times

Last updated: Aug 04 '12