I think your missing the point to NOT use hyperlink datatype. If you must store the full path to a file then just store the path as text in a text field. You can then use vba to open the file as if it were a hyperlink.
If you keep the files in folders in the same folder of the database you...