Linking Visio 2003 Professional to Access 2003 Professional

[tashnicole]

I know there's a way to do this because I saw it somewhere and now
cannot find the site.

So, for work I have an Access database that has numerous tables and
field. Basically it's a mock-up for an Asset Management System so we
have information on Pritners, Workstations, PDAs, etc. What I want to
do is pull the information from the database into a infrastructure
diagram in Visio to show how everything connects and changes. I also
want it to display the various information about each item (serial
number, asset number, name, type, etc.).

Any help would be appreciated.

 

[Al Edlund]

you might checkout the database wizard in the visio help facility for a start.
al

 

[tashnicole]

So I got everything linked thanks to the callouts.

Now here's my problem. I want to think one shape (not sure if it can
be done) to multiple tables. When I go through the wizard it only
lets me select one and when I try to make a query it just makes
everything turn into a big mess. Not good.

Also, I want to have a button, like Access, where I can circulate
through records in the database.

lastly, how can I get it to create the diagram like you can with the
space planner? So if I add a server in the database, one more will
pop up in the diagram.

Thanks for all the help.

 

[Al Edlund]

The linking of a single shape to multiple tables is not one of the functions
of the database wizard. It can be done using v2007 Professional.
Cycling through records like access would require custome code.
space planner is a custom application (add-in) that provides that
roundtripping, it sounds like you might need to write something like that as
well.
al