Menu

Detected Not Null constraint breach

Help
2016-06-14
2016-06-14
  • Joaquim Jose Hangalo

    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

     
  • Gord Thompson

    Gord Thompson - 2016-06-14

    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

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.