Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
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
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
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:
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
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:
How to create a customized "Attach ODBC Table" form
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 954192 - Last Review: October 14, 2008 - Revision: 1.0
- Microsoft Access 2000 Standard Edition
- Microsoft Access 2002 Standard Edition
- Microsoft Office Access 2003
|kbexpertiseadvanced kbtshoot kbprb KB954192|
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate