update database error

Results 1 to 2 of 2

Thread: update database error

  1. #1
    yls Guest

    Default update database error

    hi, i have a form. some are compulsory fields while others are not. so when<BR>a user updates the form, some fields are left blank and thats okay for them<BR>and in terms of flow and logic. But my update statement complains that<BR><BR>Microsoft JET Database Engine error &#039 80004005&#039<BR><BR>Field &#039maid.MaidLanguage&#039 cannot be a zero-length string.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: update database error

    In your db you need to go to edit view then on your text fields tell it that it can Allow Zero Length

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts