Hyperlink potential problems

[honey2wood]

Hi to all.
I am planning a Personnel database. In the database I want to be able to look at scanned documents for each person such as completed application forms, References, Passports etc.
I am happy to store these in a folder and then hyperlink from the database.
What I am worried about is if the folder is moved (these things happen) or moved to another part of the server. I would then have to hyperlink to all the docs again. Before I start adding these hyperlinks, is there a smart way to ensure that the links always work. I understand that access will not automatically change them.
I hope this makes sense.


Many thanks for any advice Graham

[ajetrumpet]

Graham,

There is probably no efficient way, in Access, to check for the new file location, if they are indeed moved. But...what you can do to ensure that every link you have in there is legitimate, is use the DIR() function to check a file's existence.

I believe that's right. I'm going off of memory and my personal history of making Allen Browne's codes work with my scenarios. As far as i can remember, the DIR() function in VBA is what can check the validity. Make sure the "vb" argument is correct, though!

[honey2wood]

Hi Adam

Many thanks for the quick reply. I will have a look at that. I will also have to make sure nobody moves the folder.

Once again cheers for the info