I have a table with a field named lnkPath. The lnkPath field provides links to files stored outside of the Access database.
The lnkPath field contains data like this:
C:\OPHardware\ShopB\InfoLinks\filename.extension
The path name is the same for all records. The filename.extension is different for every record.
I need to change the InfoLinks segment of the path name to LinksItem so it looks like this:
C:\OPHardware\ShopB\LinksItem\filename.extension
This only needs to be done one time, so it seems that a manually executed UPDATE query should work. But I am at a loss as to how to implement it.
Is an UPDATE query the way to go? If so, what do I put in the Update To field of the query grid?
Thanks.