Solved

VB 6.0 enterprise "DIAGRAM MENU"

Posted on 1998-11-13
5
598 Views
Last Modified: 2008-02-01
Can anyone tell me what the "Diagram" menu option on the main menu bar of VB 6.0 enterprise is for.  It appears on my installation, but all the options are inactive.  I even uninstalled and reinstalled VB, thinking that I had an install problem.  I have installed VB 6.0 SP1.  I can't find any information on this thing in any of the MS documentation, not even searching through the online knowledgebase.  I guess I must not need it, since I am working without it, but I sure would like to know why it is there....
0
Comment
Question by:rwallis1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 1

Accepted Solution

by:
tjp earned 100 total points
ID: 1444794
It's for creating/editing MS Access-style relationship diagrams.
To use it in an existing project:

1.  On the Project menu, click "Add Data Environment" (if you don't already have one; if you do, skip to 3.)
2.  Connect to whatever database you want to use.
3.  Now that you have a successful connection to a DB, go to the View menu and click "Data View Window"
4.  Expand "Data Environment Connections" and "Connection1" or whatever you named it.
5.  Right click on Database diagrams, and select "New Diagram..."

A window will open now for you to create the diagram in, but you might get a warning if you are not logged in to the database as sa or the db owner.  The Diagram menu's items will now be active as well.

There's info in the MSDN Library included with VS6, too.  Look in the contents under:
Visual Studio Documentation\Data Access Tools and Techniques\Microsoft Visual Database Tools\The Visual Database Tools in Visual Studio\Database Designer\Working in Database Diagrams
0
 

Author Comment

by:rwallis1
ID: 1444795
Well, I know how to create database diagrams as described here, however, I still don't know what that has to do with the "Diagram" option on the main menu bar.  I have created diagrams and tried every way I can think of to "activate" the main menu bar "Daigram" option.  I agree that the documentation makes it sound as if "Diagram" has to do with "database diagrams", but, you gonna have to show me someting I can do by clicking on "Diagram" or one of it's options.
0
 
LVL 1

Expert Comment

by:tjp
ID: 1444796
When the Database Diagram is the active window, the items on the Diagram menu will be available...  at least, that's the way my VB 6 Enterprise works.

Make sure you don't click on any of the tool windows in VB before you check the Diagrams menu.  If the Toolbox, Project, or Properties windows has the focus, your Diagram menu items will be disabled again.
0
 

Author Comment

by:rwallis1
ID: 1444797
Thanks for the reply.  I'll try again.  I figured it should work as you describe, but, so far, I haven't ever seen anything in "Diagram" active.  I am using ADO exclusively.  Would that have any bearing on "Diagram" being active?
0
 

Author Comment

by:rwallis1
ID: 1444798
Well, I tried again based on the following comment:

"When the Database Diagram is the active window, the items on the Diagram menu will be available...  at least, that's the way my VB 6 Enterprise works."

My VB 6.0 Enterprise doesn't work this way.  There has got to be more to this.  I have heard that the Diagram menu is active only for SQL Server, can anyone confirm this?  I am not using SQL server, I am using Progress via ADO/ODBC and Access.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question