Looking to Update Visio drawing automatically based on Access Database

[Curtis England]

I am working on a project, whereby we want to make changes in an access
database, and based on that change, update the foreground color of the
related shape....I am able to link and make it update manually by closing
and opening the drawing, but not automatically.

An example would be: we have a drwaing of a dining room with reserved
tables. when someone makes a reservation for table 1, it will be updated in
the access database. I want the visio drawing (that stays open all the time
on a second screen) to automatically change table 1's foreground to red.

Any help would be appreciated. Thanks!

 

[Al Edlund]

visio 2007 has examples of data linking and can be based on time intervals.
It sounds like you want to change the drawing based on (near real time)
database changes. Since access doesn't support triggers on record updates
you'll probably have to write code (in access, probably tagged to a form
update) to perform the update.
al