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


Groups > comp.databases.ms-access > #10841

Re: Search key not found

From "Ron Paii" <None@none.com>
Newsgroups comp.databases.ms-access
Subject Re: Search key not found
Date 2015-06-18 14:31 -0500
Organization A noiseless patient Spider
Message-ID <mlv693$4lb$1@dont-email.me> (permalink)
References <11cabf81-f1ac-4395-82bb-e920035a558c@googlegroups.com>

Show all headers | View raw



"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. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

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

csiph-web