Forum Stats

  • 3,770,598 Users
  • 2,253,140 Discussions
  • 7,875,505 Comments

Discussions

Is it possible to use Oracle dblinks from MS Access?

Konstantin D.
Konstantin D. Member Posts: 35 Blue Ribbon
edited Mar 26, 2020 4:35PM in ODBC

Say, oracle db has a link 'db_remote' pointing to remote Oracle database.

is there a way to run query 'select * from [email protected]_remote' from MS Access?

I mean, besides using pass-through query?

Or else, If I create a public synonym for [email protected]_remote, is there a way to see and link this synonym in MS Access?