My database(MS Access) reside on a different PC,
I can't establish the connection my PC and the PC which has my database.
I already used the ODBC with the "data source system"
Set strConn = Server.CreateObject ("ADODB.Connection")
strnConn.Open "data source=dsntestdb;user id=Admin;pwd=my_password"
But if the data source (dsntestdb) points to the MS Access file on the same PC, this code is very good.
I'd like to know how can we give the user id and password for connecting to the distant PC ?
Is my code is good ?