Article ID: 274167
Article Last Modified on 8/7/2007
APPLIES TO
- Microsoft Visual Basic 6.0 Professional Edition
- Microsoft Visual Basic 6.0 Enterprise Edition
This article was previously published under Q274167
SYMPTOMS
When you right-click on the Tables or Views folders (or items within those folders) under a Data Link connected to a SQL 2000 Server, the New Table, New View, Design Table, Design View, and Filter By Owner menu items do not appear. These choices exist with SQL Server 7.0.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in the next service pack for Visual Studio 6.0.
For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why
194295 HOWTO: Tell That a Visual Studio Service Pack Is Installed
To download the latest Visual Studio service pack, visit the following Microsoft Web site:
MORE INFORMATION
Steps to Reproduce Behavior
- Open a DataProject in Visual Basic 6.0.
- Create a connection to SQL Server 2000 in the DataEnvironment.
- Open the DataView window and expand the connection.
- Right-click the Table folder.
NOTE: If Visual Studio 6.00 Service Pack 5 has been applied, you see New in the context menu.
The New option displays the following error message:
REFERENCES
"Considerations for Other Microsoft Products" under "Installing SQL Server" in SQL Server 2000 Books Online.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
266277 PRB: Using Visual Studio 6 and Access 2000 Visual Database Tools with SQL Server 2000
Keywords: kbbug kbdatabase kbdataview kbdebug kbfix kbmdacnosweep kbstoredproc kbtsql kbvs600sp5fix KB274167