Article ID: 954192 - View products that this article applies to.
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.
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:
(http://support.microsoft.com/kb/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
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:
(http://support.microsoft.com/kb/210295/ )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.
Contact us for more help
Connect with Answer Desk for expert help.