[AccessD] A2003:Connect to a text file at a web address

Doug Murphy dw-murphy at cox.net
Mon Dec 20 11:57:20 CST 2004


Hi Darin,

I am getting into this late, but have you looked at the WinInet api?  It
works with Windows 98 and above and is native to windows.  I use this
control to import report data from a web site into client access databases.
I have an asp page that generates a page that is just a comma delimited text
file with a .asp extension, WinInet calls the page and loads it into a
buffer which I read out.  The page does have the normal page header but this
is easy to strip off.  In your case you could just create a simple html page
with the version # and put that on your site.

I have some reference sites around somewhere if you are interested I'll dig
them out and send offline.  Most of what I found was for VB but it works
fine in VBA.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Sunday, December 19, 2004 6:42 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] A2003:Connect to a text file at a web address


Thanks to all who responded
I will keep away from the WinHTTP object
Some of my clients are still using Win 98 (And it's not even Second
Edition<sigh>)

Here is the scenario

All I have is a text file that has a version number of that particular app.

I want my apps to look for this text file - read the contents and see it
says 6.00 Now, if the current version of the app that is looking at this
text file happens to be version 5.95 - 
a download of a new version should occur.

I just wanted to put this text file in a public place eg a web site

I actually don't wanna download the text file - just read from it

Simple right??

Anyway back to the drawing board

Again many thanks to those who responded

I will be using the download code from Gustav - it looks cool Thanks Gustav

See y'all

Darren




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Sunday, 19 December 2004 3:41 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003:Connect to a text file at a web address

Sob.  But Microsoft initially said it was redistributable. But then  I
didn't look for awhile, I have WinXP SP1 installed and the two versions
WinHttp 5.0 and 5.1 coexist side by side WinXP SP2 has another version. For
all the gory details
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winhttp/htt
p/what_s_new_in_winhttp_5_1.asp

Stuart McLachlan wrote:

>On 17 Dec 2004 at 9:25, MartyConnelly wrote:
>
>  
>
>>You can also use this on Win2000 and higher This works for me using
>>WinHttp when the site uses basic authentication:
>>There are some other winhttp methods you can use to get around server 
>>proxies etc.
>>
>>        Dim objWinHttp as object
>>        Dim strURL as string
>>        Dim strHTML as string 'your returned file
>>
>>
>>        strURL = "http://somesite.com"
>>        Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5")
>>
>>    
>>
>
>You have to be a bit careful here and it's not redistributable because
>there are different versiosn of WinHttp out there. Any of the following 
>may be required on W2K/XP systems  ...Request.5 ...Request.5.1 or 
>Request.5.1.1 you need to look at the exact version number when you create
the reference.
>
>
>  
>

--
Marty Connelly
Victoria, B.C.
Canada


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list