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

OK Thanks

DD
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, 17 December 2004 3:04 PM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] A2003:Connect to a text file at a web address

On 17 Dec 2004 at 14:35, Darren DICK wrote:

> Hello all
> I have a text file on my website
> Very vary small
> It has one line in it similar to...
> 
> 5.50,True
> 
> I want to connect to it via link tables When I type in the web address 
> I get a small dialogue saying Connecting to web server..
> Then I get an error of LINK TEXT WIZARD: Internet Login Failure
> 
> Any one know how to pass my logon name and password in this situation?
> 
> Or if anyone knows of a better situation?
> 

I don't know about A2003, but according to A2K Help:
"You cannot import from or link to a Microsoft Access database, a text file,
or an ODBC data source when importing or linking to an FTP or HTTP server."


I'd probably GET the file using FTP and then link to the local copy. 



--
Stuart


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