It is possible to have a link in one PDF point to a location in another PDF. The link type is called a “remote go-to action.” In order to create such a link using Adobe Acrobat, you must have both files open, create a link in the source file, add the “Go To Page View” action to that link, and when the “set link” dialog displays, navigate to the location in the destination file and click OK.
Note: This linking mechanism requires the directory structure to be preserved in a relative format. You may need to manually modify the created link to set a relative path and the location on your Access storage must be identical [relatively] to the location where this link was created.