Update database over internet?

[Mystified]

My database isn’t on my machine - it’s located on an NT2000 (IIS5) server -
how can the 'Data Source' path, as depicted in the expamle in the attached
thread, be local?

Shouldn't it be relative to the root directory on the server? (something
like 'Data Source=/somepath/mydb.mdb')

Reading the article suggested didn't help clarify things to me. (HOWTO: Use
the MSRemote Provider Through Client Script
http://support.microsoft.com/support/kb/articles/q240/8/38.asp )

I would simply like to access a table in an Access database on my site
(which I am the owner of) from my office computer using ADO over the
Internet.

If someone would be so kind as to suggest an answer to this question, he (or
she) would bring to an end many hours of trial and error (maily error) on my
part...

Thanks a lot,

Gary.

"chris" <chri...@microsoft.com> wrote in message
news:<OtKcAmR...@cppssbbsa01.microsoft.com>...

> Hi,

>

> After you establish the connection, you can use MSRemote provider to

> connect to and retrieve data from a remote database through internet.

> The "MS Remote" provider uses the RDS DataFactory on the remote IIS

> server to access the MDB.

>

> - If you want to use an ODBC DSN on the remote machine: oConn.Open

> "Provider=MS Remote;" & _

> "Remote Server=http://myServerName;" & _

> "Remote Provider=MSDASQL;" & _

> "DSN=AdvWorks;" & _

> "Uid=myUsername;" & _

> "Pwd=myPassword;"

>

> - If you want to use an OLE DB Provider on the remote machine:

> oConn.Open "Provider=MS Remote;" & _

> "Remote Server=http://myServerName;" & _

> "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _

> "Data Source=\somepath\mydb.mdb;", _

> "admin", ""

>

> For more information, please refer to the following article in

> Microsoft

> Knowledge Base:

>

> HOWTO: Use the MSRemote Provider Through Client Script

> http://support.microsoft.com/support/kb/articles/q240/8/38.asp

>

>

[chris]

First, make sure the latest version of MDAC is correctly isntalled on your
NT machine (iis server) so that you can use the OLE DB Provider.

Then you can use the following sample code to connect to your remote Access
database:
*************sample code*********
Dim oConn as ADODB.Connection

Set oConn = New ADODB.Connection

oConn.Open "Provider=MS Remote;" & _

"Remote Server=http://YourIISServerName;" & _

"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\somepath\mydb.mdb;", _
"admin", ""

**********sample code************
Now you can use this connection oConn as you use a local Access database.

NOTE: I'm a Microsoft Employee, and I've been "encouraged" to include the
following information from our lawyers: this posting is provided "As Is"
with no warranties, and confers no rights. That means there is no warranty
of merchantability or fitness for a particular purpose, and no warranty of
non-infringement. See full details on terms of use.