inserting a zero-length date-field in an access DB

Results 1 to 3 of 3

Thread: inserting a zero-length date-field in an access DB

  1. #1
    Isabelle Guest

    Default inserting a zero-length date-field in an access DB

    Hi Sappies<BR><BR>I can&#039t insert a zero-length date-field in my ACCESS DB, <BR> even when I set explicitely datum = null, it &#039s automatically converted into a zero-string ("") and this gives an error.<BR>When I execute the query in ACCESS, it works with the null-value, but not with the zero-string("")<BR>How can I solve this??? <BR><BR>Thanks in advance

  2. #2
    su Guest

    Default RE: inserting a zero-length date-field in an access DB

    try change your field in the table of that ACCESS DB from design<BR>so that " Allow to zero length" .<BR>I&#039m not sure but it helps usually

  3. #3
    wjp Guest

    Default RE: inserting a zero-length date-field in an access DB

    Try datum= " "

Posting Permissions

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