H
Hankado
Currently we have 5 clients with Access 2003, an ODBC connection to Oracle.
Now they all share the same Access mdb stored on the file server. We had
setup our ODBC connections to use the Oracle ODBC for Oracle and could not
run various queries. So we switched to use the Microsoft ODBC for Oracle and
we can run queries we could not before. However, ever since we made this
change every time a client opens the Access db they need to update the Table
Links other wise they get an ODBC connection failure.
All the ODBC connection on each of the clients were set up the same, basicly
identical name and everything. Is there a way to refresh the links in the
Access database only once for all workstations.
Now they all share the same Access mdb stored on the file server. We had
setup our ODBC connections to use the Oracle ODBC for Oracle and could not
run various queries. So we switched to use the Microsoft ODBC for Oracle and
we can run queries we could not before. However, ever since we made this
change every time a client opens the Access db they need to update the Table
Links other wise they get an ODBC connection failure.
All the ODBC connection on each of the clients were set up the same, basicly
identical name and everything. Is there a way to refresh the links in the
Access database only once for all workstations.