Text file on web server

[boycie]

Hi,
I am looking for a way for a user to check the latest versions of our Access db. When they log in to the db (which is a stand alone db on C drive) I want to run a routine that connects to our server via the internet and opens a text file to view the version eg . 4.13.
I know how to open and retrieve data from a text file but its the connecting to the server and opening it that I need help with. Thanks

 

[spikepl]

webservers are normally locked down pretty tight - i.e. zero external access. Make a webpage that displays the latest number, which is simple to open from the web (or Access). You could do some code that from access grabs the file via ftp (if they allow anonymous access to some resticted area) and displays the content inside Access, but it's much simpler just to make a small html page.

 

[boycie]

Hi, thanks for the reply.
Just an update. It would also work if I could just code to copy the file from the server to the C drive of the pc with db on it and then I could open that file immediately to read contents.
thanks

 

[spikepl]

webservers are normally locked down pretty tight - i.e. zero external access. Make a webpage that displays the latest number, which is simple to open from the web (or Access). You could do some code that from access grabs the file via ftp (if they allow anonymous access to some resticted area) and displays the content inside Access, but it's much simpler just to make a small html page.

Is that not clear?

 

[boycie]

This is what I have done;

Dim objHttp As Object
Dim strMsg As String

Set objHttp = CreateObject("MSXML2.ServerXMLHTTP")

Call objHttp.Open("GET", "http://mysite.co.uk/Version.txt", False)

Call objHttp.Send

strMsg = objHttp.ResponseText

I can now read in the content of the text file and use in my code.

thanks

 

[spikepl]

Smart.

Thanks for posting the solution. I have saved the link for future reference.

 

[shadow9449]

That is very helpful!

I've used wget to download data into my applications. I've described my method here:

http://www.access-programmers.co.uk/forums/showthread.php?t=175330

Your method looks really useful as it doesn't require an extra file, but parsing the response string can be a task. Using wget, I download complete tables for import.

SHADOW