Hello Guys, Need a true killer VB application that teaches you tonnes of programming techniques? Here is one. You can use this project to design entity relationship diagrams, to generate database and program code out of it. ER diagrams can be imported from databases and existing program code (classes). An Entity relationship diagram is something like a relationship diagram you see in Microsoft Access. This project provides (1) A small environment to work with ER diagrams, (2) an XML language and its DOM to describe these ER diagrams, and
(3) A control that can be used to visually represent these ER Diagrams. It supports code generation as well.
Presently, It can import ER diagrams from Access 97 database (using DAO) and Export code to ASP (with relational lookup combos for implementing relations).
Also, You can write your own plugins to import and export diagram/code from a variety of platforms. Download and see the readme file. Also visit project homepage at http://www.logicmatrixonline.com/estudio - I spend a lot of time on this, so vote please. Thanks, and enjoy coding.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Hello, please leave your comments. I spend a lot of time on this, and I appreciate your feedback for future directions. (If this comment was disrespectful, please report it.)
You have done a lot of work - thanks for sharing. I think that you will be much better appreciated if you work with a leading edge database such as SQLite (www.sqlite.com) using a recordset wrapper such as SQLiteDB.
There are too many utilities for Access - you will get lost in the crowd. SQLite is growing exponentially (it is now the defacto standard for PHP5.0) and still needs a lot of utility support.
Good Luck Ed Porter (If this comment was disrespectful, please report it.)
This will be a big help for me in an Access project I'm working on at the University. Keep up the good work (If this comment was disrespectful, please report it.)
It is not just for Access. It has a plugin interface that allows importing any database Schema. Kindly read and understand the quickstart tutorial in the readme.htm file. (If this comment was disrespectful, please report it.)
8/7/2004 11:18:41 PM:
How about some design ability. I would like to design a scheme without starting with one from a db. (If this comment was disrespectful, please report it.)
Also, I'll create and publish few more plugins for Access->Oracle Conversion, For creating MSDE Generate Script, Generating VB Classes and forms etc. I need inspiration, please vote. :) (If this comment was disrespectful, please report it.)
You can write your own schema using XML. I'll incorporate ability to design schema by next version. Right now, design in Access or code manually using XML, and import it. (If this comment was disrespectful, please report it.)
my goodness me, i'll take a ton - this code is quality number one (If this comment was disrespectful, please report it.)
8/8/2004 2:31:20 PM:
Whatever be the database used, This is one of the best Concept I have seen on this site. Seems to be very thoughtfull and original idea. Keep up the excellent work and wish you all the best (If this comment was disrespectful, please report it.)
Thank you Anoop for the terrific program you have posted. You have provided a practical and thorough example for all of us DB newbies to examine & use.
Do you have any intentions of replicating this project for ADO (and in the future, ADO.NET)?
Thanks for the terrific contribution!
(If this comment was disrespectful, please report it.)
Dear Friends, thanks for the inspiration. This project has a plugin architecture. So, it is very easy to integrate ADO, ADO.NET etc. Kindly read the included readme. I'll do that soon. Thanks again. (If this comment was disrespectful, please report it.)
You may register at our forums at http://www.logicmatrixonline.com/forum/forums/index.asp for update information. (If this comment was disrespectful, please report it.)
Great peice of code. Was working on a project to incorporate the visual query design as in access, but fell short of time. Great effort 5 all the way. (If this comment was disrespectful, please report it.)
9/25/2004 9:47:22 PM:
Excellent work brother, 5 from me keep sharing :}} (If this comment was disrespectful, please report it.)
Excellent ,please if you could call me back (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 53 Users
Download code
8/7/2004 12:52:14 PM: 
