Could someone help me with a connection string question. I need to set a connection to an access database over a network. I am only hiting the database to query some data for a report. I can Identify the database PC by IP address.
Generally I do something like this:
Dim cnn as adodb.connection
set cnn = new adodb.connection
cnn..open "Data source = (local); Initial Catalog = DatabaseName;" & " User ID = UserName; PWD = PassWord"
The problem I have now is the data source is not local, and I am not sure on the correct sytax to hit a database on a remote PC using the PC's IP address.
I would definately prefer to use the IP address if possible.
Can this be done.
If not can I just use the something like
"Data source = //RemotePCName/Program Files/Test.mdb;
Thanks
Generally I do something like this:
Dim cnn as adodb.connection
set cnn = new adodb.connection
cnn..open "Data source = (local); Initial Catalog = DatabaseName;" & " User ID = UserName; PWD = PassWord"
The problem I have now is the data source is not local, and I am not sure on the correct sytax to hit a database on a remote PC using the PC's IP address.
I would definately prefer to use the IP address if possible.
Can this be done.
If not can I just use the something like
"Data source = //RemotePCName/Program Files/Test.mdb;
Thanks
