To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104571 Issue #|104571 Summary|Can't edit database created in Access 97 anymore in 3. |1.1 RC Component|Database access Version|OOO310m9 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rafaelda
------- Additional comments from rafae...@openoffice.org Fri Aug 28 02:11:37 +0000 2009 ------- I'm using BrOffice 3.1.1 RC (OOO310m19) In Windows XP SP3. I'm also using Java 1.6.16 I have an old database created in Microsoft Access 97. I used it with BrOffice and it used to work there at least up to OOo 3.0. Now I can't update that database any more. It says "Error when inserting a new register" Step by step: Open the attached database. Click in "Tables" and in the table "DVDs" Go to the last line and include the number "92" in the column "NĂºmero" and include a new artist. Click the "Save" button and the error appears. I don't know if it has something to do with this mistake but if you are in the option "Tables", right click in the table "DVDs" and choose EDIT, you will see that the field "Eastern Eggs" has the type "SQL Null" which I haven't put there. I don't know how it got there. When I created the Database it was of the "Text" type. I tried to change it back to "Text" but there is no way to do it. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org