Combining info in a visio with a database

[JD]

Lets say I currently have a floor plan drawing in visio which can be
converter to any type of graphical format or html. This floor plan has
desk locations, phone extensions, computer serial numbers, port
numbers, etc. These type of things change when users move to a new
location.

Having a drawing like this for an entire company becomes outdated
quickly. Is there a way I can create a database with all of the
relevant information so that only the database needs to be changed and
the drawing is updated automatically using a hotspot, slice, comment
field, etc.

Anyone have any ideas that can throw out to send me down the right
path?

Thanks

 

[Al Edlund]

You might try over here

Facilities Management Web Browser (Microsoft Visio 2000 Technical Articles)
http://msdn.microsoft.com/library/en-us/dnvisio00/html/fmwebbrowser.asp?frame=true

Al

 

[David Parker]

Unless you are sticking with Visio 2000, I wouldn't go down that route. The
old Visio FM stuff was abandoned for Visio 2002.

Visio Professional Space Plan template and add-on is the way to go, with
possibly a little customisation.
You can set up spaces and have personnel, furniture & equipment
automatically positioned within these space boudaries from a database.
Then you can SaveAsWeb to present rich data diagrams on your internet, or
just use the free Microsoft Visio Viewer.