access database on the intranet

[jpmoriarty]

Okay, subsequent to previously received (very useful) assistance, can anyone give me some code to access an access database from an intranet server that's on another server in the network. I can't get to the server to map a network drive, but I want to have something like:
connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\users\dcp\intranet_be.mdb;"
is that possible?

[David Harrison]

I'm pretty sure that you'll need the IP address of the server.