在任何记录中均未找到搜索关键字 [英] The search key was not found in any record

问题描述

亲爱的，

我收到以下错误消息the search key was not found in any record

尝试从Microsoft Access 2007数据库中的表中删除记录时，会出现此消息.删除日期为<的记录时该消息将在2011年15月9日出现，但在删除日期<日期为 的记录时会出现. 14/9/2011消息不会出现，尝试使用大于或等于15/9/2011的任何日期都会生成错误.

代码已从注释中移出-LOSMAC [/EDIT]

Dears,

I have the following error message the search key was not found in any record

this message is appeared when trying to delete the records from a table in the microsoft accesss 2007 database. When deleting the records which have the date < 15/9/2011 THE MESSAGE WILL APPEAR, but when when deleting the records which have the date < 14/9/2011 THE MESSAGE WILL NOT APPEAR, trying to use any date greater than or equal to 15/9/2011 generate the error.

Code moved from comment - LOSMAC[/EDIT]

If con.State = ConnectionState.Closed Then
    con.Open()
End If
Dim cmddel As New OleDbCommand
cmddel.Connection = con
Dim deldate As Date = New Date(Now.Year, 9, 15, 0, 0, 0)
cmddel.CommandText = "delete from fuel_levels where time < #" + deldate + "#"
cmddel.ExecuteNonQuery()

推荐答案

您能告诉我您用来删除的完整查询(如果有)吗?

Can you show me the complete query you used to delete, if any?

看看下面的链接.问题似乎与"MS Access"的安装有关.

http://support.microsoft.com/kb/301474

http://stackoverflow.com/questions/206736/ms-access-reports-the-search-key-在保存的任何记录中都找不到

Have a look at below links. Problem seems to be with Installation of your "MS Access".

http://support.microsoft.com/kb/301474

http://stackoverflow.com/questions/206736/ms-access-reports-the-search-key-was-not-found-in-any-record-on-save

这篇关于在任何记录中均未找到搜索关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！