[mjacobin]

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.

[vb5prgrmr]

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