Solved

VB 6.0 enterprise "DIAGRAM MENU"

Posted on 1998-11-13
5
590 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

762 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

6 Experts available now in Live!

Get 1:1 Help Now