vb6 - How to connect to an Access 2003 database located on a web server via HTTP?

Question

I have a MS-Access 2003 located on (Http://SubDomain.DomanName.Com/Folder1/mydb.mdb) and Visual Basic 6.0 ..... how to establish connection..

im just a registered user on the host domain with sub-domain and full access to the (Folder1) Directory ....

How to connect to this (Path) .

Answer 1

You can't.

Jet is an embedded database technology. The database engine runs in-process and needs full file I/O access to the MDB, LDB, and MDW files involved.

There is the possibility of using Remote Data Service but this is an "unconnected" model of access, basically a sort of Web Service. A 3rd party hosting provider would be very unlikely to provision this service or give you the ability to yourself.

Instead you'll probably have to design and implement some sort of Web Service or otherwise run a middle tier on the server instead.