Need Help with ConnectionString Property and Access 2000

[Doughboy]

Hello,

I have a web form that adds records to an Access 2000 database. The
ASP code for connecting to the database looks something like:

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Username\Desktop\test.mdb"
objConn.Open

This works great if the database is on the same machine as the
webserver, but what if it resides on another PC on the WAN? Do I have
to mount a network share (Data Source = Z:\whatever), or can I use the
IP address of the remote machine (Data Source = 192.168.1.100)?

Thanks,


Doughboy

 

[MindwarpLtd]

Hi,

You should be able to specify the machine name.
\\server\whatever

--
Jules.
-------- MDBSecure 2004 - 30 Day Trial -------
Makes MS Access Databases more secure, based on SECFaq.
Imports existing tables, produces jet connection string.
http://www.mindwarp-consultancy-software.com/mdbsecure-free-trial-download.html
Or http://tinyurl.com/yupl5

 

[Doughboy]

Hi,

You should be able to specify the machine name.
\\server\whatever

Do I have to mount the server first if I use this UNC syntax? I'm
trying to avoid that. Is there a way to use the IP address (or
hostname) of the remote machine?