I am trying to connect via ADO to an access database. The database however is on a web host's webserver. So I am not sure if this is possible.
Able Consulting gave an example doing this via asp pages that return XML data that ADO can read as a recordset. I tried this and it worked running it on my IIS here. but when I uploaded the pages and the DB to the webhost and tried to connect in VB to the database to return a recordset it failed saying the connection was invalid.

Anyone have any idea why this doesn't work on the webserver?