Garbage in a record and I can't delete the record

[Bobbie]

One of my records is returning garbage. I tried to delete the record
it a message comes back and says Search Key Cannot be found. I don't
know what happened to the record but I sure need to get rid of the
record and recreate it as it is totaling hosing up all my month end
stats.

Thank you in advance.

[pietlinden]

Bobbie wrote:

One of my records is returning garbage. I tried to delete the record
it a message comes back and says Search Key Cannot be found. I don't
know what happened to the record but I sure need to get rid of the
record and recreate it as it is totaling hosing up all my month end
stats.

Thank you in advance.

Make a copy of the database and run a compact/repair

[Fred Zuckerman]

"Bobbie" <bo***********@yellowroadway.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

One of my records is returning garbage. I tried to delete the record
it a message comes back and says Search Key Cannot be found. I don't
know what happened to the record but I sure need to get rid of the
record and recreate it as it is totaling hosing up all my month end
stats.

Thank you in advance.

I have found this occassionally with A2K databases utilizing the database
password feature.
I've been able manually fix thuly:

1. Copy the table (ctrl-C then ctrl-V) from database window
2. Using the copy, I can usually delete the garbage record(s)
3. Delete the orginal table (or rename it for safe-keeping)
4. Rename the copy to the original table name

Good Luck,
Fred Zuckerman

[Bobbie]

Than you very much! Once I ran the Compact/Repair I was able to delete
the record.

pi********@hotmail.com wrote:

Bobbie wrote:

One of my records is returning garbage. I tried to delete the record
it a message comes back and says Search Key Cannot be found. I don't
know what happened to the record but I sure need to get rid of the
record and recreate it as it is totaling hosing up all my month end
stats.

Thank you in advance.

Make a copy of the database and run a compact/repair