Delete a record?

Results 1 to 2 of 2

Thread: Delete a record?

  1. #1
    Join Date
    Dec 1969

    Default Delete a record?

    Hi - I am trying to delete a record from an ACCESS D.B. using the syntax:<BR>SQLStmt = "delete from list where ItemNumber = "&item&";"<BR>This causes the error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e07&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression<BR><BR>What am I doing wrong? I use the exact syntax to select the record without a problem. <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Delete a record?

    is it expecting you to give it a number and you are giving it a string or something?

Posting Permissions

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