Something that has puzzled me for quite some time is whether there is a means to create a hyperlink to a file that won't break if either the location or name of the referenced file changes.
I heard from someone that every file has some kind of a unique ID that only disappears if the file is deleted.
In the ideal world, I would be able to create hyperlinks that reference this unique ID.
To put my question into context:
I intend to build a document management system in MS Access.
Documents in this system are referenced by hyperlinks in a table.
Thus far, I have a database that manages links to documents the names of which are pre-defined.
I have some code in VBA that searches through a specific location on my hard drive, looks for files with specific names and updates hyperlinks to these files in a table.
To make my system more flexible, I would love for the user to be able to point to a document, the link of which is then inserted in a table.
If the document is moved, after running my code, the hyperlink to that file should be updated. The hyperlink should also be updatable if the name of the file or its location changes.
Hence, this leads to my question of whether there a way to build a hyperlink that is independent of a file's name or its location?
Any feedback would be much appreciated.
FGP
I heard from someone that every file has some kind of a unique ID that only disappears if the file is deleted.
In the ideal world, I would be able to create hyperlinks that reference this unique ID.
To put my question into context:
I intend to build a document management system in MS Access.
Documents in this system are referenced by hyperlinks in a table.
Thus far, I have a database that manages links to documents the names of which are pre-defined.
I have some code in VBA that searches through a specific location on my hard drive, looks for files with specific names and updates hyperlinks to these files in a table.
To make my system more flexible, I would love for the user to be able to point to a document, the link of which is then inserted in a table.
If the document is moved, after running my code, the hyperlink to that file should be updated. The hyperlink should also be updatable if the name of the file or its location changes.
Hence, this leads to my question of whether there a way to build a hyperlink that is independent of a file's name or its location?
Any feedback would be much appreciated.
FGP