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 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:

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:

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