delete error

Results 1 to 4 of 4

Thread: delete error

  1. #1
    ib Guest

    Default delete error

    Newbie here,<BR><BR>I&#039;m trying to delete records in an Access Database using JET OLEDB4. This is the error I get:<BR>Microsoft JET Database Engine error &#039;80040e10&#039; <BR>No value given for one or more required parameters <BR><BR>This is the offending line:<BR>rs.Open SQLquery, connect, adOpenKeySet, adLockOptimistic<BR><BR>SQLquery="Select * FROM Calendar WHERE Calendar.drtDate&#060;18-Apr-01"<BR><BR>I&#039;ve tested that adOpenKeySet and adLockOptimistic contain variables and the connect has the following:<BR><BR>connect: Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=C:Inetpubwwwrootpcwebsite2_privateWebMgmt.m db;Mode=Share Deny None;Extended Properties="";Locale Identifier=1033;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don&#039;t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False<BR><BR>Can a kindly soul point this wretch in the right direction?<BR><BR>Thanks in advance<BR><BR>Ian Buckland<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Put the date in single quotes like..

    ..<BR>"Select * FROM Calendar WHERE Calendar.drtDate&#060;&#039;18-Apr-01&#039;"<BR><BR>

  3. #3
    ib Guest

    Default RE: Put the date in single quotes like..

    The line I&#039;m actually using uses the date function... here tis with your recommendations:<BR><BR>"Select * FROM Calendar WHERE Calendar.drtDate&#060;&#039;"&Date()&"&#039;"<BR>< BR>drtDate is an Access Date/Time Field<BR><BR>the line now gives the following error:<BR>Microsoft JET Database Engine error &#039;80040e07&#039; <BR>Data type mismatch in criteria expression. <BR><BR>I&#039;m guessing the single quotes convert it into a string<BR><BR>Thanks<BR><BR>Ian<BR>

  4. #4
    Rana Hossain Guest

    Default RE: delete error

    SQLquery="Select * FROM Calendar WHERE drtDate &#060; #18-Apr-01#"

Posting Permissions

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