Help!! Cannot Delete a 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, this sounds like your database file is partially corrupt.

1. First, close Access. Check the folder where the file resides. If you see
another file there with an ldb extension, delete it. It will be a very small
file, and contains spurious locking information if Access did not close
properly. While you are there, make a back up copy of the mdb file without
overwriting any other backups you have.

2. Open you database in Access. From the Tools menu, choose:
Database Utilities | Compact/Repair.
This gets rid of any temp stuff.

3. Next, from the File menu, choose New.
Create a new Database with another name.

4. From the Tools menu, choose Options.
On the General tab, uncheck the Track Name Autocorrect boxes.

5. Import everything from your old database into this new one:
File | Get External | Import

You may find that the damaged table does not import correctly, but you
should be able to get everything else. If the table fails to import, post
back for further suggestions.
 
Back
Top