Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10838 > unrolled thread

Search key not found

Back to article view | Back to comp.databases.ms-access

Contents

  Search key not found Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-06-18 07:13 -0700
    Search key not found internet.shopping@foobox.com - 2015-06-18 09:46 -0700
    Re: Search key not found PW <emailaddyinsig@ifIremember.com> - 2015-06-18 11:23 -0600
    Re: Search key not found "Ron Paii" <None@none.com> - 2015-06-18 14:31 -0500

#10838 — Search key not found

Access 2013.  I have a table.  It contains 1 record.  I have a query to select records from that table.  When I run the query, I attempt to delete it.  I click on the row and press the delete button.  I get a message that states "The search key was not found in any record."  I can't delete it.  So I open up the table.  Click on the row and attempt to delete it.  I get the same error message.  The only way I can remove the record is to create a Delete query.

Any idea what this error means?  Any idea why I can't delete the record from the table?

[toc] | [next] | [standalone]

#10839

Try Compact And Repair on the data file

[toc] | [prev] | [next] | [standalone]

#10840

On Thu, 18 Jun 2015 07:13:58 -0700 (PDT), Patrick Finucane
<patrickfinucanetx@gmail.com> wrote:

>Access 2013.  I have a table.  It contains 1 record.  I have a query to select records from that table.  When I run the query, I attempt to delete it.  I click on the row and press the delete button.  I get a message that states "The search key was not found in any record."  I can't delete it.  So I open up the table.  Click on the row and attempt to delete it.  I get the same error message.  The only way I can remove the record is to create a Delete query.
>
>Any idea what this error means?  Any idea why I can't delete the record from the table?


*---

That is weird. I hope that never happens to us!  I assume you tried
compacting and repairing the DB (you may get the same error message).
And that there are no related records in other tables?  Is there an
index that you can remove?

See anything here?:

https://support.microsoft.com/en-us/kb/301474
http://bytes.com/topic/access/answers/890918-search-key-not-found-any-record-error
https://www.google.com/search?q=microsoft+access+error+message+%22search+key+not+found%22&oq=microsoft+access+error+message+%22search+key+not+found%22&aqs=chrome..69i57.15883j0j4&sourceid=chrome&es_sm=93&ie=UTF-8

-paulw

[toc] | [prev] | [next] | [standalone]

#10841

"Patrick Finucane" <patrickfinucanetx@gmail.com> wrote in message 
news:11cabf81-f1ac-4395-82bb-e920035a558c@googlegroups.com...
> Access 2013.  I have a table.  It contains 1 record.  I have a query to 
> select records from that table.  When I run the query, I attempt to delete 
> it.  I click on the row and press the delete button.  I get a message that 
> states "The search key was not found in any record."  I can't delete it. 
> So I open up the table.  Click on the row and attempt to delete it.  I get 
> the same error message.  The only way I can remove the record is to create 
> a Delete query.
>
> Any idea what this error means?  Any idea why I can't delete the record 
> from the table?

The record is corrupted. If compact / repair doesn't work; Delete the table, 
compact / repair, recreate the table. 

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web