Visual Basic 6 and Microsoft Access connectivity via HTTp / FTP

Visual Basic 6 and Microsoft Access connectivity via HTTp / FTP

Page 1 of 1

1 Replies - 4110 Views - Last Post: 18 July 2009 - 10:44 PM Rate Topic: -----

#1 mjacobin  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 18-July 09

Visual Basic 6 and Microsoft Access connectivity via HTTp / FTP

Posted 18 July 2009 - 01:42 PM

Hi All,

Lately I have been working on project and it has hit a road block as the database needs to be on internet to collect data and the client needs an application on his system only that needs to connect to the internet and start accessing the data.
The application works fine with database existing on the local system. I have been trying hard get hold how to do the connectivity for the Access database located on HTTP / FTP server as the port 80, 81, 20 and 21 is not blocked by the hosting site rest of the ports are blocked.
con.Open ("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=ftp://66.132.181.22/httpdocs/Data/PREQ.mdb;")
. Kindly advice for the connectivity code.

Is This A Good Question/Topic? 0
  • +

Replies To: Visual Basic 6 and Microsoft Access connectivity via HTTp / FTP

#2 vb5prgrmr  Icon User is offline

  • D.I.C Lover

Reputation: 109
  • View blog
  • Posts: 1,016
  • Joined: 21-March 09

Re: Visual Basic 6 and Microsoft Access connectivity via HTTp / FTP

Posted 18 July 2009 - 10:44 PM

To be honest, I don't think you can do that with an MDB but you can with MySQL. Perhaps with the information from this...

http://www.connectionstrings.com/mysql

You might be able to get it to work for access. If not then I would suggest that you upgrade to MySQL or higher.


Good Luck
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1