I have VB6.0 (SP5), SQL Server 7.0 (SP3) and MDAC2.5(SP1). I got SQL Server with a training book I bought called "Master DB Programming with VB6.0".

After installing VB and SQL Server, I have been trying to follow the section on VB database tools. I establish a data link in the data View to the NWIND using the "sa" ID. When I right click on any of the database diagrams (table, views, etc) there isn't a "Design" or "New..." option as described in the book, on MS knowledge base or this web-site. I can't add/edit/view any of these objects.

I tried the MS web-site. They describe this as a known problem with SQL Server 2000 and VB6.0. The fix is to install VB 6.0 SP5. I have SQL 7.0 but I installed SP5 anyway just to see. It did not help. The "sa" ID is the system admin for SQL Server so I wouln't think it was a security issue. Does anyone have any ideas at all?