Solved

VB 6.0 enterprise "DIAGRAM MENU"

Posted on 1998-11-13
5
593 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
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 Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now