I have a database I’ve used in Access for many years but have decided to convert to Base. I’ve set it up again from scratch, importing the data tables and recreating the main query, relationships and data input form.
I can edit existing records via my main query or form (that links to the main query), but whenever I insert a new record either in the form or the query, I get this message:
Attempt to insert null into a non-nullable column: column: System table: Main in statement [INSERT INTO “Main” ( “Box”, “Manual”, “Name”, “Players”, “Type”, “Year”) VALUES ( ?, ?, ?, ?, ?, ? )]
Not only have I set the table to allow null entries, these fields aren’t null! If I enter the data directly into the main table, that the query references, it works.
Any ideas? The database is here if anyone minds having a look:
https://dl.dropboxusercontent.com/u/50053/Games%20TEST%20FORM%203.odb
Using Base in LibreOffice 5.0.2.2, Java 8U65, on Windows 7. I have also tried it on the same versions of LO/Java on OS X El Capitan with the same issue.