un deletable entry

[habbabub]

i have an entry in my table but when i go to delete it it doesnt work
so im stuck with it

the error message i get when i try to delete it is
"THe search key was not found in any record"

 

[Moniker]

OK, that one makes no sense. Can you go to the table and just click the Delete key on your keyboard and remove it? It sounds like you have Master/Child links and the master link is empty while the child link is not (tough to do, but I've seen worse). This sounds more like a custom "Delete" function that's trying to key off of a certain value from a different field that cannot be found. For example, if you have a master table like this:

ID   SomeValue
1    Value1
2    Value2

And you have a subform like this:

ID   SomeValue
2    Value2
3    Value3

And then you try to delete ID 3 and it looks on the first table for ID 3 to delete, well, it cannot find the record to delete because it doesn't exist.

I am sort of curious if the data relationships got setup after the DB was initially setup, which would potentially cause that issue.

 

[habbabub]

there isnt much relationships at all with my table..

all i did was create a table from the wizard. and thats the only one that exist..
when i double click on the table. the table pops up, when i highlight the row and try the delete it with the delte key i get the error.. and it dosent get removed

 

[WayneRyan]

H,

Make a copy of your database and then:

Tools --> Database Utilities --> Compact/Repair

That should fix the problem.

Wayne

 

[boblarson]

Wayne's suggestion should work as you have a corrupt record. But, you also after doing the compact and repair may need to go actually delete the record. It may still be in your table but without the key field. I just had to deal with that a couple of weeks ago at a client site.