Corrupt record - can't delete?

[Rowena]

Greetings,
I have a record in my database that appears to be partially corrupt - the ID number is readable, the first and last names are there OK, other random information is all right, but a few of the fields are showing up as random characters.

I have no idea what happened here; I have the tables in a BE on the server and am working with forms from my workstation, and don't recall seeing any warning messages.

My first thought was to delete the bad record and re-enter the information. So I went to the menu and chose "delete record", fully expecting it to delete the record. No dice. I got an error message saying "Search key not found in any record."

So I tried to re-enter the data in the messed up fields. That didn't work either. I got the error message where you can close the database object but any changes will be lost.

Grumble!!
The silly thing had actually been working, too...

Thanks in advance for any help,
Rowena

 

[Rowena]

Just in case I can't fix the bad record, is there a way to import the good records into a clean table? I can't find anything in the Help file that seems to address this problem.

I did a brain-dead thing and didn't back up often enough -- my last back-up copy has 67 records, I am now up to 108, and the bad one is #80.

any thoughts on this would be appreciated!!

Thanks!

Rowena

 

[[nateobot]]

Not really sure how that happened. If you cannot figure it out what we did here as a similar "fix" was:

1. Copy (ctl+c) the old table.
2. Paste the old table and select structure only.
3. Open old table and new table.
4. Select (in your case) records 1 - 79 and then paste them into the new table.
5. Do the same as above but start with 81 - last record.

-nate

 

[Rowena]

nate,

Okay, I can copy the old table's structure, no problem. I can open both tables, and select the records, too.

Why won't Access let me paste them into the new table?

Ctrl+V does nothing, and the Edit menu doesn't give a paste, or even a "paste special" option.

Can you help?

Thanks in advance,
Rowena
(we need a "tearing out hair" smiley!)

 

[[nateobot]]

You are selecting the records and copying them right?

Sorry have to ask i know i mess up that way sometime when getting upset.

After you have them copied to the clipboard highlight the first row (blank) in new table. Then paste it in. All should work quite well.

 

[Rowena]

Okay, I have to paste one record at a time, but it's working so far.

I guess it's just not able to do multiples. Still better by a long ways than trying to re-enter all those records...
Thanks for your help!
Rowena

 

[John.Woody]

Once you have selected multiple records and copied them to the clipboard control V won't work. If you go to the edit menu and select Paste Append this should append all the records to the new table.

HTH
John