The search key was not found in any record. (Error 3709)

F

fishy

I have a number of records that look like chinese caused when staff open the
same record at the same time. I have tried setting the locks etc but still
get the occasional one.

a) how do I stop staff going into a record already open &
b) how do I get rid of the corrupt rows (I cannot export and reimport after
tidying as these refs are customer specific so cannot be resequenced).
 
T

Tom Wussernark [MSFT]

this is called 'database corruption'

if you want to avoid it then you need to move to SQL Server

sorry
 
T

Tony Toews [MVP]

Tom Wussernark said:
this is called 'database corruption'

if you want to avoid it then you need to move to SQL Server
Click to expand...

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
J

Jody

<BUMP>
I too am having this problem. I didn't know until I read this post WHY I
was having this problem, but it makes sense. I have a corrupt record in my
db that has a rod ID (auto number set as primary key) that is completely out
of sequence by several thousand - and this db only has about 300 records. I
get the same error as described "the search key was not found in any record".
I cannot export the table and remove it - it errors out. I cannot
copy/paste the information because when the chinese charcters are displayed,
it locks up the db.

Any suggestions?
 
P

Pieter Wijnen

Make a table based on the corrupt one

SELECT INTO newTable
SELECT * FROM Corrupted
WHERE ID < 10000

Might do it

Pieter
 
T

Tony Toews [MVP]

Jody said:
I too am having this problem. I didn't know until I read this post WHY I
was having this problem, but it makes sense. I have a corrupt record in my
db that has a rod ID (auto number set as primary key) that is completely out
of sequence by several thousand - and this db only has about 300 records. I
get the same error as described "the search key was not found in any record".
I cannot export the table and remove it - it errors out. I cannot
copy/paste the information because when the chinese charcters are displayed,
it locks up the db.
Click to expand...

To add to Peter's response in case that record is in the middle of the
autonumber sequence.

See the Corrupt Records in a Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top