https://bugs.freedesktop.org/show_bug.cgi?id=43187

             Bug #: 43187
           Summary: EDITING - MSAccess 2007/2010 (.accdb) table data not
                    editable/updatable - read only
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO Master
          Platform: x86 (IA32)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs@lists.freedesktop.org
        ReportedBy: alex.thurg...@gmail.com


Now that the bug for gaining access to MSAccess files has been fixed in master,
I can report another bug.

How to reproduce :
1) Start MSAccess 2010
By default in MSAccess 2010, the table wizard always creates a primary key on
the first autonumbered field. Accept this default.
2) Add a text field or two.
3) Add a DATE/TIME field
4) Save.

Now start up sbase :
1) In Database wizard, choose "connect to existing db"
2) Select Access 2007 in the list of choices in the dropdown menu.
3) Accept defaults proposed by wizard then save the ODB.
4) Open the ODB file pointing to the MSAccess db (.accdb).
5) Double-click on a table in the list of tables.
6) Note that the data is not writable, but read only. Also note that new
records can not be added to the table.

Expected : should be able to add new records, and update/modify existing data.


Note that this does work for MSAccess 2003 files (read/write).


Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to