Visio drawing to auto fill Access database?

[Gretchen Chocensky]

Has anyone ever tried to have access tables read a Visio drawing? My boss
tells me has witness this, but I can't find any reference to it.

 

[Guest]

Hi Gretchen

I'm not sure what you want to do

What you can do with Visio drawings is
1. Import the whole drawing into a field type OLE object - this stores the drawing within Acces
2. Link a Visio drawing using a Hyperlink field - stores only the filename and pat

What you can't do is evaluate the drawing and it's content - or at last I don't see how, as Visio is only using vector graphic

Bernd

 

[Terrell Miller]

-----Original Message-----
Has anyone ever tried to have access tables read a Visio drawing? My boss
tells me has witness this, but I can't find any reference

to it.

Gretchen, the only way to get Access to interact with
Visio is if you have the version of Vision included in
Visual Studio Enterprise Edition, which IIRC costs $10-20k.

That's teh only version of Visio that can "forward
engineer" ER diagrams into Access tables.

The Professional edition of Visio (or whatever the next-
highest version is called) will let you reverse-engingeer
Access tables, so you can in effect import an ER diagram
into Visio based on your table structure in Access. But
you can't go the other way and actually create tables in
Access based on your Visio ER diagram.

*Unless* you buy the full-blown version of Visual Studio.

Would be nice if Microsoft chose to actually say all that
up front, but if you look over at the Visio newsgroups you
will find at least one thread every week where somebody
found out all this the hard way.

HTH,

Terrell