ACC2000: Linked Table Manager Does Not Display All Linked Oracle Tables (323658)

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

When you start the Linked Table Manager in a Microsoft Access 2000 database that contains linked tables to an Oracle database, the following may occur:

Only one table appears in the Linked Table Manager.
No linked tables appear in the Linked Table Manager.
A timeout error appears as the Linked Table Manager is loading the list of tables.

CAUSE

The Oracle server returns a synonym for each table name that is mapped to each available user name, thereby causing the list of available tables to exceed the 64,000-character display limit for the combo box that the Linked Table Manager uses.

This typically occurs when there is either a large number of Oracle tables, a large number of Oracle users, or a combination of both. For example, an Oracle database with 300 tables and 300 users would return 90,000 table synonyms, rather than returning 300 table synonyms to the Linked Table Manager.

RESOLUTION

The following steps describe how to modify the AttachableObjects subkey in the Windows registry and how to delete the Synonym value from the Value Data list.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Start the Registry Editor and move to the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC
Right-click the AttachableObjects string value, and then click Modify.
Delete the following text from the value list:
,'SYNONYMS'

REFERENCES

For additional information about issues with linked Oracle tables in a Microsoft Access database, click the article numbers below to view the articles in the Microsoft Knowledge Base:

264012 PRB: Connectivity Issue with MDAC and Oracle8i

239103 PRB: Synonyms of DBLinked Tables Do Not Show in Data View Window

271524 PRB: Oracle Synonyms Associated with Database Links Not Listed by OLE DB Provider or ODBC Driver