Using VB to access a MSAccess 2 database over the internet

I am trying to add some code to a program I am writing to access a database on my web site over the internet.

My ISP has supposedly set up a DSN for the database and I have read a bunch if different suggestions on how to do this but to no avail.


I am using VB6 and would like to basically open a database from multiple locations at the same time.

The database name is: netmanager.mdb and is an Access 2 database. I keep getting a server error and am not convinced that the ISP has everything set up right. Can someone give me some example code that points to an existing remote database toprove to me that this is even possible?

Any help would be greatly appreciated.

If you are running the Visual Basic code from remote machines, you will need to set up the DSN on each remote machine to be able to access the MS Access database on your ISP's webserver.

Do I get the DSN from my ISP?...I am very new to database programming..

You will get the DSN parameter information from your ISP. Server ID, username, password port and any other pertinent information. Contact your ISP and tell them you need the information necessary to set up a DSN to communicate from your machine to their MS Access database.

I am not sure if this helps but if you are using VB.NET I just got done doing an example of this but I am using a mySQL database, XML and PHP.

WebRequest XML Dataset Import

Description: This example shows you how to perform an asynchronous web request to retrieve data from a XML web service. It then parses the data and adds records to an OLE compliant datasource.

It is pretty cool I do a WebRequset from my program and the website sends me back XML which I then parse out and insert into my local database. Hope it helps with the concept