Run-time error 3709

[AndyWatt]

Hi All,

I've come across what seems to me a very bizarre error:

"3709 The search key was not found in any record."

This occurs when one of my clients attempts to update one specific record in a Jet 3.0 database. My app is written in VB6.0 SP5 and uses DAO 3.6.

I have verified the existence of matching primary keys in all tables.

Any ideas? As far as I can see other posts on this have concerned Jet 4 databases...

Your help will be much appreciated.


Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"Why does my program keep showing error messages every time something goes wrong?"

 

[CCLINT]

Does it happen only when a user edits the same newly added recorded, added by that same user through the same recordset?

 

[AndyWatt]

Thanks for the reply,

I have added, edited and deleted records and been unable to reproduce this behaviour except with the one record that was exhibiting this problem in the first place. Most odd. The record in question only started doing this last Friday (20 Jun) and it had been successfully updated eighteen or so times since it's creation several months ago.

I have discovered that using Access 2000's compact and repair routine has fixed the symptom, if not the cause.



Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"Why does my program keep showing error messages every time something goes wrong?"