Is it unacceptable to use Google link shortened with Access?
I think you mean in Access, use a link that has been shortened?
Are you using application.followhyperlink? I doubt Access is able to work with a "zipped" path using that method.
Or it could be related to security issues that are blocked by Windows or a system policy. See http://allenbrowne.com/func-GoHyperlink.html
Also, what is a "long" url? 1000 characters or more? That seems to be at or near the upper limit for followhyperlink.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.