Automating production of visio diagrams from access 97 data

[countzero]

I have been asked to look into using access and visio together. <br>I suppose the best way to describe this is the database contains locations and links<br><br>e.g. location A is connected to B and direction is from A to B<br>location B is connected to C and direction id C to D<br>etc.<br>I then want to do a diagram from the access data - set of nodes or boxes with A at centre with linking lines to C and D etc. with direction of links.<br><br>Not having used Visio and access together yet - I am not sure what would be involved.<br><br>but essentially query access to get all connecting points to and from A. Construct the diagram.<br>Would this involve VBA or scripting - is this standard functionality or bespoke?<br>Thanks

 

[Guest_imported]

You could try my tutor on access db his name is David Wren and is available at

http://www.wren-enterprises.co.uk

 

[kb2000]

Hi,
being not really familiar with Visio, I had to reach the goal to produce a diagram showing relations of modules and Interfaces kept in an Access-DB. All the automatic stuff is badly documented.I finally came across the text-import-feature.
To do this, I had to produce reports on queries against the models and their linkage. These reports produce one line for each module, one for each interface and a link from one to another. It looks not very good, but is correct and producable without too much effort (it remains to concatenate the different reports and produce a flat text-file as import). Besides that, you have to prepare (once)a &quot;master-drawing&quot; holding the shapes and links to use. Basically I found all information in the online help.
To give you an idea, I'll post some lines of it following this text. It's in german, but I hope you won't mind.
Right now I am looking for hands-on experience for direct db-connection, that I haven't found yet.
Regards

template,u:\it\glossary neue it\glonit_daten\qms-color_a3.vst

master,&quot;glonit-modul&quot;,&quot;datenblock&quot;,p:\visio50\loesungen\software-diagramm\datenobjekte.vss

master,&quot;glonit-IF&quot;,&quot;datenmodul&quot;,p:\visio50\loesungen\software-diagramm\Shlaer-Mellor OOA.VSS

master,&quot;glonit-link&quot;,&quot;verallgemeinerung&quot;,p:\visio50\loesungen\software-diagramm\UML - Statische Struktur-Shapes.VSS

shape,KT_Stammdaten,&quot;glonit-IF&quot;,&quot;KT_Stammdaten&quot;,,,1.5,0.3
shape,M8_IT,&quot;glonit-modul&quot;,&quot;Labor W-Bonus&quot;,,,,

Link,,&quot;glonit-link&quot;,&quot;7&quot;,KT_Stammdaten,M8_IT