Losing hyperlinks when file moved Access 2007

[lkevinc42036]

Hi, I have a problem. I have an Access file on a network server along with a folder with a lot of pdf files. When I created the hyperlinks, all I did was drag the pdfs from the file to the table in my Access database. However, Now I have made a copy of my Access file to another network server and the hyperlinks no longer work. How do I recover the working hyperlinks of my database?



Thanks

[help_me_with_access]

what's the format of the data in the access file? if it's an attachment field, you will have to change them manually unless you can find a level 2 property that deals with the file's location/address (that would be one property level below the property of "type" for the DAO object "field"). But I'm doubtin you'll get that. no idea if there is one. but if there is, it could probably be coded if it's a writable property.

if your field IS actually a hyperlink field, you can use visual basic to change all of those values by looping through the file location and re-assigning values.