Can i embed MS Access database inside Visio and query it using VBA

Hi , Iam Deepu.

Is it possible to embed an MS access database file in a Visio drawing and when i click on a shape, query and display the information related to the shape from the database in a msgbox or so?

My requirement is that i do not want an additional file to be carried along with the visio document. That is why i wanted to embed it in the same drawing.

Welcoming all your suggestions.

Thanks.

Deepu

[444 byte] By [DeepuMukundan] at [2007-12-23]

«« POOM MessageInterception for incoming emails
»» EMAIL

# 1

Hello Deepu,

I doubt very much you will be able to embed a database into a visio document, but that doesn't mean you cannot embed the data. For example you could have a module that contains all the data you want to search as an array or as a collection. Its not a database in the classic sense but it is data storage.

The best solution would be to use XML and query it using the objects in MSXML. XML is text based so you can put it in your code as a string but it's structured data so you can query similar but not exactly the same as a database.

DerekSmyth at 2007-8-30 >