Can I use Access 2007 to do mass hyperlink edits?

[Rebecca]

I have thousands of hyperlinks in Excel that I need to edit due to the files
being moved. How can I do a "find and replace" edit of the target address,
not just the display text? Can it be done in Access??

 

[Wayne-I-M]

Yes you can do it in access but you need to give more details to get a
workable answer

 

[Rebecca Sage]

Thanks Wayne,
Folders have been reorganized, and more subfolders added to collection of
pic files. The ftp address is the same but filenames, folders, and subfolders
are not in many cases. In other words, I need to change just part of the
hyperlink address for groups of 10-80 files at a time. Is there any other
info I can give you?
Thanks!!

 

[Pete D.]

If they are in a table in access you can use an update query something like
this SQL

UPDATE tbl_BinderID_Location SET tbl_BinderID_Location.FileHyperLink =
Replace([tbl_BinderID_Location].[FileHyperLink],"Lfiws1lrs807\d_lgrvm\TECH
ORDERS","Lfiws1lrs822\lgrv_data\TechOrders");

 

[Pete D.]

Sorry, I was going to paste this also and just clicked send. I'm a new
Grandpa today, must be the sudden age change. Try this to do it in excel.
http://cnx.org/content/m17228/latest/

If they are in a table in access you can use an update query something
like this SQL

UPDATE tbl_BinderID_Location SET tbl_BinderID_Location.FileHyperLink =
Replace([tbl_BinderID_Location].[FileHyperLink],"Lfiws1lrs807\d_lgrvm\TECH
ORDERS","Lfiws1lrs822\lgrv_data\TechOrders");

Thanks Wayne,
Folders have been reorganized, and more subfolders added to collection of
pic files. The ftp address is the same but filenames, folders, and
subfolders
are not in many cases. In other words, I need to change just part of the
hyperlink address for groups of 10-80 files at a time. Is there any other
info I can give you?
Thanks!!