Alter records in Access Table

[cwhite2010]

Hi

Im new and this is my first thread

Im hoping some of you kind people can help me?

We have a database which has a table with 2 fields - here is an example of the data:

Order File Path
240971 cclapps1\scanner\Works Orders 2008\Works Orders 2008\ITL1\ITL1TMSPC11.GFD


We basically need to change the file path to read cclapps3 instead of cclapps1 in every record.

Can someone guide me (step by step) on how to achieve this please?

I have limited knowledge ...

Many Thanks
Carla

 

[CJ_London]

You can change the names to suit in this query

UPDATE myTable SET Path = Replace([Path],"cclapps1","cclapps3")

 

[misscrf]

If it is really that simple, you can just open the table and do a find and replace for any part of the field. Always back the table up before doing that kind of action, just in case you find there is a sub-string in the path that also has what you are trying to find and replace.

Sometimes we don't need fancy solutions for a one off issue.