Visio/Access inteface view diagram as database table(s)

G

gardoglee

Visio 2003 offers some tools and wizards to export and import attributes of
Visio objects to an Access table. There are also included very limited
facilities for creating a Visio drawing from a CSV file, or other structured
data. It would be more helpful (and indeed, a very useful feature) if Visio
could offer an actual 'view' of a drawing as a table or set of tables which
could then be manipulated to update the drawing. This could be similar to
the manner in which Access and a number of other Office tools allow flipping
between views of a query, seeing the query either in the graphical builder,
or as SQL code, or as a simple grid result set.

My current example is a Visio diagram of a number of interelated systems,
and my attempt to build a consolidated diagram showing all of the shapes from
the individual subsystems, and the interfaces between them. It would be very
helpful if I could run SQL queries, and particularly updating SQL queries,
against the sets of shapes from all of the diagrams in order to standardize
terminolgy, typefaces, positioning, and the whole host of things which need
to be updated. As it sits with Visio as delivered, there are some very
limited features and capabilities to assist, in this, but the amount of
manual manipulation which the inbuilt capabilities would require is great.
Similarly, there are enough programming capabilities in Visio to allow me to
build tools which would faciltate this, but the time to learn the Visio data
model, code the routines I need, and then use them is prohibitive, since I
need to deliver my documents soon.

If anyone can point me toward some available tools or Visio capabilities
which act more in the manner I have described, I would greatly appreciate it.

Gary Lee
(e-mail address removed)
(e-mail address removed)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...112edbbff&dg=microsoft.public.visio.developer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top