I have been looking for answers for hours, but just do not seem to exist. I have a database that is tracking files in a repository but currently the database and the repository cannot talk to each other. As part of data being tracked, I have people copying the web address where the file is located so from the database they can link directly to the file.
From the form when I right click on the field in question, the paste option is greyed out (copy is available). I have attempted to troubleshoot and attempted linking that field to different queries or the main table, no luck. All other fields on the form, have the paste option, just this one field. I have attempted to create a new field in the database table with the hyperlink attribute and the new field has the same restrictions.
The question is, is there a way to allow users to paste the hyperlink into the database? I want it as a hyperlink field so from the database they can just click the link to go to the document. The current database is a split database hosted on corporate network. Any help would be greatly appreciated.