Hyperlinks and Access

  • Thread starter Thread starter beans
  • Start date Start date
B

beans

Guest
Hi,

I am a newbie at Access and this forum. Here is the question I have a database set-up in Access'97 which recently got converted to Access'03. Now previously database reside on my computer and I have a field that holds hyperlinks to documents which were set as relative paths. Now the database has been moved to another location..where ofcourse the relative path don't work, as the parent directory is different. There are a huge number of records in the database with hyperlinks. I need to convert all relative path to absolute paths. Is there an easier and faster way of doing this? Perhaps via a query? I don't want to do this one by one.

Thanks in advance for your help.
 
Path

How about you establish the path for one document and then use that
data to do a Search and Replace in the table.
 
Do a backup first!

:D
 

Users who are viewing this thread

Back
Top Bottom