I wouldn't use a hyperlink data type. That was another poor datatype added with A2007. It isn't supported in SQL Server so although it isn't terrible like muli-value fields or table level lookups, it also isn't upsizable.
Just store the full path OR keep a table where the path is stored and then store just the file name or detail path in each product record. Then you would use the FollowHyperlink method in VBA to open the document. This method relies on Windows file associations. So, ANY file type that windows knows how to open can be opened with this method. If you use Shell(), YOU need to know what application is needed to open any particular file so it is much less flexible.