• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / Visio 2013 / Linking an Access Web Database to Visio

Published on September 16, 2015 by David Parker

Linking an Access Web Database to Visio

There is a great video on Channel 9 about Access Web Apps, and how to link to them on the desktop ( see https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps). However, they never mentioned linking to Visio, so I thought I would correct that omission. I had previously tried to use Link Data to Shapes with an Access Web database, but failed, however watching this video encouraged me to try again!

image
image
image
SNAGHTML10800e75
image
image
image
image
image
image
image
image
image
image
image


First, I created an Access Web Application in my Office365 site, based on the OrgData.xls workbook that is installed with Visio. I created three tables from the workbook, and then created an Access query to add in a little more features.

I was an early convert to Microsoft Access, and bought version1.1 with my own money, years before I started using Visio. So I am very used to creating interesting useful queries such as this one which creates calculated columns which will be used in Visio later.

The info backstage screen enables me to view the read-only connection information.

So, I copied these SQL Server Connection Information values for use later….

Next, I used the Create Reports button to create a new desktop Access database. Although this is not strictly necessary for just linking to Visio, it automatically opens up the firewall on my desktop PC. This is essential for using the SQL Server connection information, and anyway, I get a reporting database to play with too!

Now I can use the Link Data to Shapes button in Visio.

I selected the Other/Advanced option…

Then, I select the SQL Server Native Client 11.0 data provider:

I then entered the SQL Server information that I copied earlier… but I added @<first part of server name> to the end of the User name (after ExternalReader) as in the video.

The Test Connection succeeded!

I then selected my query to link to… (note that you should only need to link to those owned by Access).

I ticked Save password in file ….

This is then saved into an ODC file, which can only be used on this particular desktop PC because of the firewall.

I noticed that the Phone and MailTo columns were not automatically interpreted as Hyperlink types, so I corrected that.

Then I had my data linking to my shapes in Visio!

QED

Related

Filed Under: Access, Office 365, Visio 2013, Visio 2016 Tagged With: Link Data to Shapes, Office365, Visio

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. Terence Sterba says

    April 22, 2020 at 8:17 pm

    I am wondering how to a link my MS Access database to a Visio Diagram picture

    Reply
    • David Parker says

      April 28, 2020 at 10:32 am

      Access is a built-in source for data-linking, https://bvisual.net/category/access/
      But Access is not a source (any more) for the Reverse Database Diagramming wizard, though there is possible alternatives https://bvisual.net/category/diagram-types/database/

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Copyright © 2023 · Executive Pro on Genesis Framework · WordPress · Log in