Microsoft Access Client Hangs Trying To Link Table Over Database Link
Last updated on JULY 18, 2014
Applies to:Oracle ODBC Driver - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Oracle ODBC Driver - Version 220.127.116.11 and later
Microsoft Windows x64 (64-bit)
Database link hangs when attempting to link a table from Microsoft Access 2010 to Oracle database using Oracle ODBC driver.
The issue can be consistently reproducible with below scenario.
1. Have 2 databases, Local database (A) and remote database (B). Create a database link between the 2 databases.
2. Create a public synonym in database A for a view in database B.
3. Using MS Access, create a linked table to consume public synonym from database A.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms