PRB: Cannot View Table with More Than 40 Fields in SQL Browser

Article ID: Q124394
Creation Date: 29-DEC-1994
Revision Date: 30-DEC-1994

The information in this article applies to:

Microsoft Access Upsizing Tools version 1.0

SYMPTOMS

When you try to view a SQL Server table in the Microsoft Access Upsizing Tools SQL Server Browser, you receive the following error message:

   You can't browse a table or view with more than 40 fields. To browse
   it, attach and open it from the Microsoft Access Database window.

CAUSE

The SQL Server Browser tool limits the tables it can display to those with 40 fields or less.

RESOLUTION

To view a table with more than 40 fields, attach the table to an existing Microsoft Access database and then view the table in Microsoft Access.

To view or manage SQL Server defaults, triggers, or stored procedures, use a Microsoft SQL Server utility such as SQL Object Manager, ISQL, or SQL Administrator.

STATUS

This behavior is by design.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.