f



Errors: "No current record" and "The search Key was not found in any record"

Hi

I get the errors
1) No current record
2) The search Key was not found in any record

while deleting data from a table

it is a simple delete, as: delete from asd where record_time < 39585
or where record time > 39585 and < 39586

They result in the errors above, in the same order.

Data is present in the table.

What causes this?
0
sonnich (155)
5/29/2008 8:08:28 AM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
605 Views

Similar Articles

[PageSpeed] 41

On May 29, 11:08=A0am, jodleren <sonn...@hot.ee> wrote:
> Hi
>
> I get the errors
> 1) No current record
> 2) The search Key was not found in any record
>
> while deleting data from a table
>
> it is a simple delete, as: delete from asd where record_time < 39585
> or where record time > 39585 and < 39586
>
> They result in the errors above, in the same order.
>
> Data is present in the table.
>
> What causes this?

Another common problem is at any time "not a valid bookmark"
Mostlty when reading data
0
sonnich (155)
5/29/2008 9:02:32 AM
These messages can be triggered by a bad index.

Try a compact/repair. 
In Access 2007, click the Office Button (top Left), then Manage.
In previous versions it's on the Tools menu.

More info:
    Recovery sequence - Standard steps to recover a database
at:
    http://allenbrowne.com/recover.html

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jodleren" <sonnich@hot.ee> wrote in message
news:32a55cb7-a3b4-4dbb-8519-b6325c4e4d7f@j22g2000hsf.googlegroups.com...
> 
> I get the errors
> 1) No current record
> 2) The search Key was not found in any record
> 
> while deleting data from a table
> 
> it is a simple delete, as: delete from asd where record_time < 39585
> or where record time > 39585 and < 39586
> 
> They result in the errors above, in the same order.
> 
> Data is present in the table.
> 
> What causes this?
0
AllenBrowne (3681)
5/29/2008 9:33:07 AM
Reply: