Linking to ODBC Linked Tables

[Lynda]

Hi:

I wonder if you have any suggestions for this. We have moved our Access
tables into Oracle and have created a MS Access Database that links to these
ODBC tables. Each of our users has a local copy of our Reporting Database
that formerly linked to Access tables, but now we want them to link to the
Ms Access Database which contains the linked ODBC tables on our shared
drive. In trying to link to already linked ODBC tables, Access gives an
error and will not link to these tables.

Is there a way to let our users link to the Access database that contains
the linked ODBC tables?

Any suggestion would be appreciated.

Lynda

 

[John W. Vinson]

Hi:

I wonder if you have any suggestions for this. We have moved our Access
tables into Oracle and have created a MS Access Database that links to these
ODBC tables. Each of our users has a local copy of our Reporting Database
that formerly linked to Access tables, but now we want them to link to the
Ms Access Database which contains the linked ODBC tables on our shared
drive. In trying to link to already linked ODBC tables, Access gives an
error and will not link to these tables.

Is there a way to let our users link to the Access database that contains
the linked ODBC tables?

Any suggestion would be appreciated.

Lynda

I don't believe you can link to a link. Why not just have each frontend link
directly to the ODBC tables?

John W. Vinson [MVP]

 

[Dale Fye]

Lynda,

My guess is that you are using DSN connections to the tables in the Oracle
database, which means you have to create the DSN on each users machine.

As John, said, I recommend that you link your application directly to the
Oracle tables, then write some code to change the connection to a DSN-less
connection and will not have to create DSN's on each of your users computers.

Google on: +Access +VBA +DSN-less +Oracle

Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.