M
Matt B
Hi Visio Guru's & Enthusiasts,
I am developing a Visio (2002) solution where I have shapes linked to data
in an Access database. The Visio solution is basically a cable management
add-in, where one may draw wiring plans then manage the allocation of cable
number's and wiring of multi-core cable to connectors, including KRONE and
patch panels.
Currently I am using VB forms and ADO to access the database, within Visio.
For each Visio Shape I am currently storing the shape GUID, Name and Page in
the database as well as other data such as: Equipment Vendor, Details etc.
These shape details are stored after the user opens the appropriate VBA form
(R. Mouse the shape), not actively using the built-in database wizard linked
to shape properties.
Thinking ahead to the time I unleash this Visio Solution to my peers I have
a rather important data synchronisation issue.
In the event my Visio document becomes corrupt, what would I need to do to
re-create the Visio drawing from the database, specifically what shape
properties (X-Y location, shape name, page etc.) would I need to store the
data?
As a shape may be adjusted, moved etc. many times during use of the document
would I need to write the above properties to the database each time the
shape is manipulated or should this be done on document open close?
What are the database "got-ya's" I might need to consider given the scope of
my visio solution & the importance of the data?
Best Regards,
M@
I am developing a Visio (2002) solution where I have shapes linked to data
in an Access database. The Visio solution is basically a cable management
add-in, where one may draw wiring plans then manage the allocation of cable
number's and wiring of multi-core cable to connectors, including KRONE and
patch panels.
Currently I am using VB forms and ADO to access the database, within Visio.
For each Visio Shape I am currently storing the shape GUID, Name and Page in
the database as well as other data such as: Equipment Vendor, Details etc.
These shape details are stored after the user opens the appropriate VBA form
(R. Mouse the shape), not actively using the built-in database wizard linked
to shape properties.
Thinking ahead to the time I unleash this Visio Solution to my peers I have
a rather important data synchronisation issue.
In the event my Visio document becomes corrupt, what would I need to do to
re-create the Visio drawing from the database, specifically what shape
properties (X-Y location, shape name, page etc.) would I need to store the
data?
As a shape may be adjusted, moved etc. many times during use of the document
would I need to write the above properties to the database each time the
shape is manipulated or should this be done on document open close?
What are the database "got-ya's" I might need to consider given the scope of
my visio solution & the importance of the data?
Best Regards,
M@