I am using an Access database on a network. I'm not sure what the PAD319205' is and can only assume that is the designation for the machine the database resides on. The following is the code I am using to make the connection and I copied it from another source. It is possible I neglected to alter the code for the database I am using, but will need guidance in figuring this one out. Thanks.
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Set cn = New ADODB.Connection
SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPathToDB & ";Persist Security Info=false"
cn.Open (SQL), , , 0
|