how can I access a Visio shape's database properties from VBA?

[SteveH]

I'm using Visio 2003. I have a Visio drawing that is sourced from a SQL
database (using reverse engineering). The shapes are tables. In the database
properties of each shape, the physical and conceptual name are set correctly.
However in the special fields, the name of each table is just set to 'Entity'.

I'm running a VBA macro which must identify each shape (table) by its
correct name. I'm faced with having to manually copy the physical name from
database properties to the name in the special fields. I'm wondering if VBA
can do this for me but I can't see how to read the database properties from
within VBA.

I'd be grateful for any suggestions ...

 

[Al Edlund]

unfortunately the database modeling tool is a closed application where some
of the data is stored internally and not available via a program interface.
al

 

[SteveH]

Then is there any way to tailor reverse engineering so that the SQL table
name can be used to populate the Visio shape name (instead of just giving all
shapes the name 'entity')?

 

[Al Edlund]

I would suspect that what you are working against is not a visio question,
but rather a question relative to how the addin/addon works. That specific
addin is owned by the ms group that owns visual studio...
You might check these guys out
http://www.orthogonalsoftware.com/products.html

al