Help!! Cannot delete record...

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

Help, I was inputting some data in one of my forms when suddenly I got an
error and the record was basically turned to fields with little 'squares'
and when i go into the table it will not let me delete it and gives an error
of "The Search key cannot be found in any record!" when i try to change the
data. THen it says "That someone else is attempting to change the same data
at the same time" But it is only me on the computer and no one else can get
to this database but by this computer. Anyone have any ideas??? PLEASE
HELP!!!!
 
Chip,

You could try to make a new copy of your table (definition
only), and then manually copy all the other records form
the old to the new one. Following that, with a bit of luck
you should be able to delete the whole table and rename
the new one to the old one's name (you might need to
change queries using the table).
Anohter thing you might try is to import the table in
another database... again, with a bit of luck, the
problematic record might not make it accross (assuming the
table will!). If this works, then import everything else
to the new database as well, and get rid of the old one.
In either case, I would get my antivirus up to date and
run a scan just in case (if you haven't already).

Good luck,
Nikos
 
Hopefully you have a backup of your data. What you have
to do is goto Tools, then Database Utilities... then goto
Compact and repair database. After it does this it will
delete the record that is corrupted. If you have an old
database copy that record backinto the table and there
you go. Also check to make sure that the table in
question has a primary key as sometimes access removes
the primary key on corruptions
 
Back
Top