Error 3709

  • Thread starter Thread starter Andy Green
  • Start date Start date
A

Andy Green

A record in one of the tables in my database has become
corrupt following a network connection problem.

I have tried the compact & repair feature of Access,
although this crashes.

I then to delete the record, altough I am faced with an
error "The Search Kay Was Not Found In Any Record".

The help feature then tells me about error 3709.
'This error occurs when an ISAM SEEK is being executed
and there are no matching values in the index.'

Does anyone know how I can delete the record, or can
resolve the issue in another way?

Thank you.
 
Andy

If you know which record it is, another approach might be to:

FIRST BACK UP!
build a new table (same structure as old)
build a query that extracts all the rows UP TO the error row
convert that to an append query, into the new table
do the same for rows FOLLOWING the error row
enter the data from the missing row
throw away the old table, use the new one (renamed, of course)
Click to expand...

You will need to be absolutely clear on minding your keys (primary and
foreign) and relationships.
 
Back
Top