update database

Results 1 to 2 of 2

Thread: update database

  1. #1
    yls Guest

    Default update database

    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 Because ....

    You never stop do you? You busy &#039lil thing.<BR><BR>If your are using MS-Access then you need to set the fields Required property to No and Allow Nulls to True. Do this by opening the table in design view and changing the propeties there.<BR><BR>It&#039s pretty much the same for whichever db you happen to be using.<BR><BR>HTH<BR><BR>Darren<BR>[ darren@showusyourcode.com ]

Posting Permissions

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