Hyperlinks and Access

[beans]

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.

 

[trucktime]

Path

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

 

[jrjr]

Do a backup first!