To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87514 Issue #|87514 Summary|mdb/ado: field not NULLable in table / form - but by S |QL Component|Database access Version|OOo 2.4.0 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|hmssg
------- Additional comments from [EMAIL PROTECTED] Thu Mar 27 16:15:26 +0000 2008 ------- The content of a once filled field cannot be erased in a form or talbe when using a mdb database as backend. Instead a message appears: "Fehler beim Schreiben des aktuellen Datensatzes" (german version). To reproduce the problem: - Copy the attached mdb file to c:\temp\test123.mdb - Create a new odb file (File / New / Database / Exisiting ... / Microsoft Access / "C:\temp\test123.mdb") - go to "tables" - double click on table "customers" - delete the content "xxx" in column "remark" with backspace/delete-key - save the record (by pressing enter or clicking the symbol) - the error message occurs The same happens, when using an ADO connection (PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\temp\test123.mdb) instead of "Microsoft Access"). Remarkable is, that executing the following SQL statement via Extra / SQL ... works as expected: update customer set remark = '' where id = 1; --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]