Querying remote database

[grunners22]

Hi

We have an online form for customers to fill out - this data is then placed into an mdb on the same web server. What I want to do is query this database from our intranet, but to do this I need to create a connection to the remote database, which is where I am hitting trouble. When everything is local, this all works perfectly with the following connection syntax:

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "J:\Inetpub\wwwroot\intranet\TESTING\cgi-bin\database.mdb"

Obviously just putting a url in place of the Intranet path didn't work, that would be far too simple.

Any ideas?

Thanks