VB database tools and SQL Server

[dawright]

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?

[TheBao]

When I right click on any of the database diagrams (table, views, etc) there isn't a "Design" or "New..

I did this and got it works. I used SP5 for VB6 as well.

Regards,
TheBao

[Edneeis]

Is it some kind of scaled down half version of SQL? Maybe those functions are disabled.

[paulw]

It isn't usually a scaled down version. I got an 180 day trial version and it is the full monty. Check your permissions anyway and ensure that you haven't got read only access to that area.

Check your Public role and use GRANT ALL - if you still can't get in then I'm stumped.

Cheers,

P.