Can you build an Access database from a Visio diagram?

[Pablo]

I'm building a simple database app with Access, and thought that rather than
using the Access wizards, I would start the process by working out the
relationship details in a Visio Database diagram. Now that I have that
diagram built, can I have access building its tables and relationships
automatically from the Visio?

 

[Duane Hookom]

There are versions of Visio that support this. Check your Visio Help for
additional information.

 

[Pablo]

I'm using:

Visio Professional 2003 SP1 (11.4301.6360), and I only came here after
spending a lot of time in Help trying to find out how to do this. Does this
version support creating (and hopefully modifying) Access table and
relationship structures?

Thanks

 

[Brendan Reynolds]

I'm not a Visio expert, Pablo, but I don't think it does. I think the
'Enterprise Architects' edition of Visio that comes with Visual Studio is
the only edition that includes that feature now. But I'm not 100% sure of
that - you might get a more definitive answer in a Visio newsgroup.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Tim Ferguson]

Visio Professional 2003 SP1 (11.4301.6360), and I only came here after
spending a lot of time in Help trying to find out how to do this. Does
this version support creating (and hopefully modifying) Access table
and relationship structures?

It's one of these things that are rumoured in the marketing stuff, but I
have never heard of anyone managing it, nor have I had any success myself.

You can export to SQL Server or MSDE, though, which is probably more
relevant if you are going to the trouble of getting visio to design the
thing in the first place.

Ideal solution would be a SQL DDL output, but I can't find that either.

All the best


Tim F

 

[Pablo]

Turns out that I have an Enterprise Architects version with the Visual Studio
2005 Beta CDs. So I installed them, and voila, the Generate Database
capability is there. Works pretty neat too, although lots of questions I
don't know the answer to relative to the Access connection.

Thanks for the response.

PL

 

[Pablo]

Tim: It's in the Vision Enterprise Architect's version, and I happen to have
a copy with the Whidbey beta disks. Works pretty neat.

Thanks for the reply
PL