2007 Viewer, DB, Code issue

[tealeaf412]

Hi.

I'm new to Visio and VBA programming, so please excuse my ignorance.

I built a Visio diagram that runs custom code to update itself based
on an Access database, but it seems to crash when used with the 2007
Viewer.

When the user loads the diagram in the full version of Visio (I use
2003 Professional), they are prompted to choose whether to update the
diagram. If they choose yes, the diagram programmatically connects to
an Access database. It clears out all the current shapes, then
creates a new shape for every database record, calculates coordinates,
and drops them in the diagram. There is no problem with this in the
full version.

When using the viewer, if I choose to disable macros when the file is
opened, the diagram obviously does not update but loads fine. If I
enable them, the prompt appears for a split second and then the viewer
closes itself.

I have not been able to find any information from MS or elsewhere
regarding whether the viewer supports the kind of functionality I
need.

Does anyone have any insight into this? Is this just not possible
using the Viewer, or is it an error with my code? Has anyone had any
success with using the Viewer in this way?

Thank you in advance.

 

[Al Edlund]

The visio viewer control does just that, you can look at a document (not
execute embedded code), but you don't need visio on the system. The visio
drawing control (allows you to change what you are looking at) requires that
the visio product be installed on the system that is working with the
document. The viewer doesn't like embedded code either.
al

 

[tealeaf412]

I thought that might be the case, but the fact that the prompt showed
up at all made me think that maybe running code was possible.

Thanks for your reply.