Only the first 12,000 tables appear in the Link Tables dialog box in Microsoft Access 2000, Microsoft Access 2002, or Microsoft Office Access 2003

Article translations Article translations
Article ID: 954192 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

A SQL Server database contains more than 12,000 tables. You use the SQL Native Client Open Database Connectivity (ODBC) driver to link to the database from Microsoft Access 2000, Microsoft Access 2002 or Microsoft Office Access 2003. However, only the first 12,000 tables appear in the Link Tables dialog box.

RESOLUTION

To resolve this problem, apply the Jet 4.0 Database Engine cumulative hotfix package. For more information about this hotfix package, click the following article number to view the article in the Microsoft Knowledge Base:
954193 Description of the Jet 4.0 Database Engine cumulative hotfix package for Windows XP Service Pack 2 and Service Pack 3, Windows Server 2003 Service Pack 1 and Service Pack 2, Windows Vista, Windows Vista Service Pack 1, and Windows Server 2008: July 2, 2008

WORKAROUND

To work around this problem, create a form that uses the TransferDatabase command to attach tables from an ODBC data source. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
210295 How to create a customized "Attach ODBC Table" form

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 954192 - Last Review: October 14, 2008 - Revision: 1.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 2002 Standard Edition
  • Microsoft Office Access 2003
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB954192

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com