Security Concern

[Learn2010]

I have a database that I use to store hyperlink files in. I have used this before in different versions of Access, 2003 to 2013, which is part of Office 365.The field in the table is a hyperlink field. I use a form where I right click on the hyperlink field, edit the hyperlink, and then find the file.

The latest database I created (2013) to use this in is now presenting a problem. When clicking on the file to link it, I have to name it. Let me use an example. When I click on the file to link, I get something like this in the Address window (..\Location1\Location2\Test.pdf). Normally, I would remove everything except Test.pdf and save it as that. When I do that, and later try to open the hyperlink, I now get two messages. The first is a security warning about a potential security concern. I click on yes and get a second message telling me it was unable to open the file. However, if I leave the entire name that is displayed in the Address window, it will give me only the first security warning but it will open the file.

This has never happened before in any of my databases. In this one I added the folder as a Trusted Location and it still happens. Does anyone know what is happening here?

Thanks.

 

[static]

Address is the file path. If you change that Access can't find the file.
Change 'text to display' to whatever you like.

The security warning is because Access is a bit thick and can't work out that it's a trusted folder from a relative rather than absolute path.