Unanswered: Can I call an ASP script from Access to upload files?
Does anyone know if it is possible to call an ASP page on a remote web server and pass it parameters?
I have an Access 2002 database that I want to use off-line to gather data and images and then upload the lot to a web application running SQL Server. Getting the data into SQL isn’t a problem but I need to be able to run a script that will upload the images to a folder on the web server.
I’m running out of hair to pull out on this one, so any help you can give would be greatly appreciated.
Thank you for taking the time to reply. That looks like the solution I need, I hadn't realised you can call a hyperlink from code, but based on your post, I'm planning to use a function something like this:
Public Function UploadIt(FileName As String)
Dim strAddress As String
On Error GoTo Error_UploadIT
' Create the hyperlink address.
strAddress = "http://www.myserver.com/myscript.asp?filename=" & FileName