Hyper link

[Ayed]

I have a database in my pc with more than 10,000 records. Most of the records were linked with hyperlink to pdf files.
The hyper link was c:\workfiles\data
now i moved my database to the company server with all data and hypelinked files.
The new location is oa-server1\eng\workfiles\access\data
the problem is that the hyperlink is not working any more and i need to re-link each record again.
My question: Is there a way to tel access to find the new location of the linked files.

Thank you

 

[robina]

If the hyperlink is the same for all records, I would do an update query to update the table.

 

[Ayed]

many thanks for prompt reply. actually each record is linked to a different pdf file but all the files are in one direcroty.
i need access to search for the files in the new director.

 

[pbaldy]

Looks like my neighbor to the south is offline. I'd do the same thing; you'd use the Replace function to change the path stored in the table:

Replace(FieldName, "c:\", "\\oa-server1\eng\")