Big Error

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.

Is there a way to remove the YED-14- without doing it manually or
requesting IT to restore the database from backups, and return the values to
there original values.

This will really save us embarrasement.
Thank you ever-so-much.
 
An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.

Is there a way to remove the YED-14- without doing it manually or
requesting IT to restore the database from backups, and return the values to
there original values.

This will really save us embarrasement.
Thank you ever-so-much.
Click to expand...

If you are certain that *every* occurance of YED-14- should be removed, run an
Update query updating this field:

UPDATE yourtable
SET thisfield = Mid([thisfield], 8)
WHERE thisfield LIKE "YED-14-*";

Make a fresh backup first just in case!!
 
You can also open the table in datasheet view and place the cursor in the
soiled field. Use find and replace from the edit menu. Select to find the
value anywhere in the field.
--
Duane Hookom
Microsoft Access MVP


John W. Vinson said:
An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.

Is there a way to remove the YED-14- without doing it manually or
requesting IT to restore the database from backups, and return the values to
there original values.

This will really save us embarrasement.
Thank you ever-so-much.
Click to expand...

If you are certain that *every* occurance of YED-14- should be removed, run an
Update query updating this field:

UPDATE yourtable
SET thisfield = Mid([thisfield], 8)
WHERE thisfield LIKE "YED-14-*";

Make a fresh backup first just in case!!
Click to expand...
 
Back
Top