I have a simple on line web form that collects data and sends it into an Access Database held in a folder called "HR". It also uploads a users resume, which is uploaded to a file folder called "Uploads" located in "HR". I have created a snippet of code that works great if I run it from an access db on the server:
Option Compare Database
Private Sub Command50_Click()
FollowHyperlink "uploads/" & Me.filename
HOWEVER, when I try to replicate this function with a local version of the access database (with linked tables) on my desktop, updating the path, I get an error message that reads: Cannot locate the internet server or proxy server. I have permissions set.
Here is the code I am using to try and grab the resume from my local (desktop) version.
Private Sub Command148_Click()
FollowHyperlink "y:/hr/uploads/" & Me.filename
NOTE: "Y" is my mapped drive letter to the server.
Any help will be GREATL APPRECIATED