PDF files generated from database show security warning that need to be turned off

I am generating reports from an Access database with links to files in a sub-directory. When viewing the report in Access, the links work fine to open linked files with the Windows associated applications (by the file type). The link field in the Access report is a hyperlink with a text value consisting of <file name>#.\<sub-diretory name>\<file name># In the exported PDF file, clicking on a link results in two warning messages, such as the following:

and

Questions:

• Is there a way to eliminate the second warning message? And is there a way to do so programmatically? Such through a batch file or executable code?
• Also, is there a programmatic way to effect the setting in the Acrobat security preferences for the first message?
• Or is there some other way to eliminate these messages the would preferable?