Visio Guy

Solution-specific Visio Discussions => Database Diagramming => Topic started by: pborgschulte on April 28, 2016, 06:32:16 AM

Title: Bi-directional data exchange - Visio 2010 / Access 2010 and/or SharePoint 2013
Post by: pborgschulte on April 28, 2016, 06:32:16 AM
Dear community,

I have "played" already with the shape data connected to an external data source. I use Access 2010. It seems however that the refresh only works into one direction, i.e. from Access to Visio. How about the other way round, i.e. updating the Access database table or SharePoint list with updated Visio shape data? Can this be activated somewhere?

Thanks!


Ciao,

Patrick
Title: Re: Bi-directional data exchange - Visio 2010 / Access 2010 and/or SharePoint 2013
Post by: aledlund on April 28, 2016, 08:48:01 AM
"activated" - there is no native ability to round trip information between a linked source and visio. It would require custom code.
al
Title: Re: Bi-directional data exchange - Visio 2010 / Access 2010 and/or SharePoint 2013
Post by: pborgschulte on April 28, 2016, 10:29:41 AM
"activated" - there is no native ability to round trip information between a linked source and visio. It would require custom code.
al

Hi Al,

Thanks for the feedback. I just googled a bit and it seems that there is a possibility when setting up an ODBC connection. I am trying this out now.


Ciao,

Patrick
Title: Re: Bi-directional data exchange - Visio 2010 / Access 2010 and/or SharePoint 2013
Post by: pborgschulte on April 29, 2016, 12:10:30 PM
I got a nice possibility from the page: http://www.bluepecantraining.com/portfolio/connecting-your-visio-drawing-to-an-excel-database-in-visio-standard/

I will try this with SharePoint and Access as well ...


Ciao,

Patrick
Title: Re: Bi-directional data exchange - Visio 2010 / Access 2010 and/or SharePoint 2013
Post by: jw76novice on April 30, 2016, 12:08:31 AM
Patrick,
I recall playing around with the Database Wizard a year or so ago, and it did handle data bi-directionally for me (Visio to Excel and vice versa), but I recall not liking how the interface worked for some reason.  I'd say you're on the right path and look forward to what you post next!
Title: Re: Bi-directional data exchange - Visio 2010 / Access 2010 and/or SharePoint 2013
Post by: Yacine on April 30, 2016, 02:40:21 AM
Hi Patrick,
I enclose a packaged zip file containing an Access DB, which does the bi-directional data exchange.
The key is to invoke Visio from Access, then create persistent objects of the active window and the selected shape.
The rest is plain VBA as if you were in Visio itself.

HTH,
Y.