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
Can i embed MS Access database inside Visio and query it using VBA
Benin
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.
Giovanni Rivas
Hi Derek,
Thanks for that post.
Even i was planning to do it in the same way you suggested.
Just wanted a ferw suggestions from you all if any other alternative was available.
Thanks Once again.
Regards,
Deepu