Using VBA to Link Shapes with an Access Database?

[Matt B]

I am currently working on a visio solution which now requires a rather
intense data solution.
Up until now I have been using Excel Sheets, embedded in the Visio Document,
to store my data.
Loads of VBA forms & modules link data from the shapes to the Excel Sheets.

I have found the Excel Sheets no longer provide manageable solutions for my
databasing needs and I would like to move to an Access Database solution.
(Not that an Excel Sheet is really much of a database anyway)

The problem is I have no real knowledge of the VBA methods required to
access & manipulate an Access Database, within Visio. I have spent quite a
few hours looking for help, examples and other Visio solutions which use VBA
to drive an Access Database but have not found anything really useful.

I am really after the fundamental stuff:
* Opening the Database file (or getting it if embedded in the Visio
Document)
* Searching the database
* Reading & writing data in the database.
All the usual stuff required to pass data between shapes VBA and the Access
Database.

If anyone has any code examples, helpful URL's or could recommend book it
would be very appreciated.

I already have a few Microsoft & WorldWare books on Developing Visio
Solutions however these do not cover the VBA methods for Access. Maybe I
need a book on developing Access solutions?

Best Regards
Matt B

 

[Al Edlund]

I'd consider two approaches
a.) check into David Edson's book which has several good examples (John
Marshall has some pointers on his site at www.mvps.org/visio)
b.) look into msdn.microsoft.com office products visio 2000 technical
articles, specifically the one that talks to network configuration.
Al