Microsoft KB Archive/323658

= ACC2000: Linked Table Manager Does Not Display All Linked Oracle Tables =

Article ID: 323658

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q323658



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'



