У меня все работает, MSDE2000+Sp3a, Access2000+Sp3, MDAC 2.8
Только я этими конструкторами не пользуюсь - есть средства разработки/управления для сиквела гораздо симпатичней акесных

З.Ы.
Вот нашел (статья большая, куча рекомендаций- ищите в инете)

PRB: Using the Visual Studio 6.0 and Access 2000 Visual Database Tools with SQL Server 2000 Q266277

If you want to design SQL Server 2000 databases in Visual Studio or Access, you must install the latest version of the Visual Database Tools

The first step was a hotfix that was included in Visual Studio 6.0 SP4 and Office
2000 SR-1. This interim step fixed a few of the issues with Stored Procedure
enumeration, and made the Table, View and Diagram Designers read-only. The
designers were made read-only to prevent the serious data and meta-data loss
bugs that may have occurred.

The second step was a SQL Server 2000 compatibility release of the Visual
Database Tools. This version is included in SQL Server 2000 Client Tools, and will
be available in the next service pack of Visual Studio 6.0 and the next service
release of Office 2000.