Combine a Visio Drawing with a Access Table or form.

[MacALF]

I have a visio drawing of equipment in communications Racks. Each Card has a
Field Position Index (FPI) Rack.Row.Card Number. or 1.1.1 to 22.8.8.

I have an Access Database that contains all the data related to the FPI.

How can I combine the two so I can click on a card and the data will be
displayed either on a popup form or filter a datasheet?

Remember I have over 500 cards so numbering each card in the diagram could
be a long process.

 

[Al Edlund]

That functionality is not standard so you would have to write code to do it.
Curious on how many machine and card types you have to manage? Do you also
require documenting cabling between the racks? I found it was easier for me
to have a set of custom properties that I would populate when drawing the
racks (so the database is the master). The other thing was to modify a rack
stencil object so that the connection points would map correctly, as well as
the products I place in the rack. The very good news is that it appears
you've started with a structured naming system.
al

 

[Scott]

Hi Al,



In the post below you mention writing code to do what the person was asking.
We run into a similar situation, where as we have to update drawings then
update a database on a very large scale on our network back-bone. I have been
racking my brains trying to tie the two together. This would keep me from
doing double the work.



My question to you, do you have any running examples of ways you have tied
the data base and Visio together in a Rack, equipment, card, cross
connections between racks/equipment?



Thanks for any help you can give,
Scott

 

[Bill Morein [MSFT]]

You might want to take a look at some of the new features that we are
putting into the next version of Visio: http://blogs.msdn.com/eric_rockey/