UCanAccess forces read-only access on tables containing values that violate the NOT NULL constraint on a column. If you need to update one of those tables then you must use Access to either remove the null values from the column or drop the NOT NULL constraint on the column (i.e., set "Required" to "No").
Last edit: Gord Thompson 2016-06-14
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How can I disable that verification in ucanaccess-3.0.6
My Url is that
getConnection("jdbc:ucanaccess://D://desenvolvimento/procura.mdb; readonly=true; showSchema=true");
My database is old, with old data and I Wan't change line by line.
Can you help me?!
Thanks
See the related thread here:
https://sourceforge.net/p/ucanaccess/discussion/help/thread/2fa4764f/#8732
UCanAccess forces read-only access on tables containing values that violate the NOT NULL constraint on a column. If you need to update one of those tables then you must use Access to either remove the null values from the column or drop the NOT NULL constraint on the column (i.e., set "Required" to "No").
Last edit: Gord Thompson 2016-06-14