Connecting to Access db on a network drive via ODBC

[Keith]

I'm trying to connect to an MS Access database which is
located on a different network domain from my VBA code. I
have a network drive set up and I have an ODBC connection
called "HH" set up through that network drive to the db.
However when I try to create a connection using:

Set DB_Connection = CreateObject("ADODB.Connection")
DB_Connection.Open("HH")

I get the error "[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed". If I copy the db to the same
domain as my VBA code and point the ODBC to it, everything
works fine.

Any network guru out there have any suggestions? Would be
much appreciated.
Keith

 

[Jaime y Rey]

I'm trying to connect to an MS Access database which is
located on a different network domain from my VBA code. I
have a network drive set up and I have an ODBC connection
called "HH" set up through that network drive to the db.
However when I try to create a connection using:

Set DB_Connection = CreateObject("ADODB.Connection")
DB_Connection.Open("HH")

I get the error "[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed". If I copy the db to the same
domain as my VBA code and point the ODBC to it, everything
works fine.

Any network guru out there have any suggestions? Would be
much appreciated.
Keith