I am using asp.net and ado.net to update an Access 2000 database.
It works OK except, after minimal use, I get an error message:
-----------------------
"The search key was not found in any record."
System.Data.OleDb.OleDbException: The search key was not found in any
record.
Line 46: Dim objCommand As New OleDbCommand(strSql, objConn)
Line 47: objConn.Open()
Line 48: objCommand.ExecuteNonQuery()
Line 49: objConn.Close()
Line 50: End Sub
-----------------------------
This happens when I try to UPDATE a table, and only occurs
for aspecific row in the table.This is a brand new database. I created it
from scratch a few minutes ago.
Any ideas as to what the problem might be?
By the way, I notice that this seems to occur with just about every database
I use. I think the problem may have something to do with the frequency of
how often I save data to the table. When I try to save data slowly,
carefully, it works OK. When I try to save often, I get this error which
corrupts the database. I actually think that the connection to the db is
still open when I try to save again.
Does that make sense? In other words, I have a command button that runs the
ExecuteNonQuery method, and I am "testing" the database my clicking
repeatedly. When I click often, the database becomes corrupted. When I
click, then wait several seconds, then click again, no problems.
Could this repeated, fast clicking be the problem?
