Cardyin,

The code is no different to any other ADO insert code.  This looks to be
an Access problem and I think I am going to have to pursue it from
there.  If you are interested, the error message turns out to be an
Access error message.  Here is Access XP help files definition of the
Error:

The search key was not found in any record. (Error 3709)
This error occurs when an ISAM SEEK is being executed and there are no
matching values in the index.

I am not sure I really understand this, but I will research it from
there.

Thanks,
Yehuda

-----Original Message-----
From: Kim, Cardyin [mailto:CKim@s...]
Sent: Friday, July 20, 2001 6:12 PM
To: professional vb
Subject: [pro_vb] RE: getting an error


Yehuda,

Can you give us some sample code?  Meanwhile, search keys are usually
the WHERE clause part of your recordset.  They assist the data provider
in determining which records qualify for your recordset and which don't.

Cardyin

-----Original Message-----
From: Yehuda Rosenblum [mailto:Yehuda@I...]
Sent: Friday, July 20, 2001 11:31 AM
To: professional vb
Subject: [pro_vb] getting an error


I am trying to update an access database and am receiving the following
error "[Microsoft][ODBC Microsoft Access Driver] The search key was not
found in any record."  Does anyone have any clue what this means?  I am
using Access XP (also have tried it on 2000) and VB 6.0 SP4.  I am
connecting to the Database using ADO.  The connection is DSN-less.



---
You are currently subscribed to pro_vb as: yehuda@i... To
unsubscribe send a blank email to $subst('Email.Unsub')