Re: Which Version of Visio is this? - Access Database from Visio

if all you desire is to draw the diagram, then the professional versions should be adquate. If you want to 'forward engineer'/'create ddl' then you need the enterprise architect edition which came with visual studios enterprise architect edition.
al

"JAA149" <JAA149@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:6631A071-6251-4948-A7A0-9260399B0CF7@xxxxxxxxxxxxxxxx
Dear Paul,

It is not in Visio 2002 Pro, Not in Visio 2003 Pro & not in Visio 2007 Pro.

On searching the web sites i found

http://www.win.tue.nl/~rp/visio/2mdb

"Generating an Access database from a Visio database diagram" which explains
How to convert Database Model Diagram in Visio 2000 Enterprise to a Microsoft
Access database". But the methods used including the commands/menues are
totaly different from the Book.

And another one

http://www.skandus.com/visio.htm

for "Data Modeling with Access and Visio" which states "The latest version
of Visio—Visio 2002.........The ER model itself does not allow you to export
to a new or existing database. To export a model, you'll need to use the
Database Model template..............."

But it is not in Visio 2002.

What is to be done is simple.

1 - Create a ERD diagram in Visio.
2 - Automatically generate a Access database from the ERD diagram.

PLEASE HELP.

Regards

Jawad

"Paul Herber" wrote:

On Fri, 28 Nov 2008 07:28:04 -0800, JAA149
<JAA149@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I am new at database modeling and reading a book called "Absolute >Beginner’s
>Guide to Databases By John V. Petersen" which uses (Old Versions) Visio >&
>Access for examples. But the book does not say which versions. In the >book
>the author makes an ERD diagram using the Crow's Feet ERD.VST from the
>Solutions/Database folder using the "Create Database Wizard". Which >version
>of Visio is this.
>
>How to make a Access Database from Visio? Is this function availabe in >all
>versions.

Must be Professional.


--
Regards, Paul Herber, Sandrila Ltd.
DFD/SSADM for Visio http://www.visio-dfd.sandrila.co.uk/


.

Relevant Pages

  • Re: Networking diagram & audit
    ... So are you suggesting I just use Visio to create the diagram and put ... >use Visio as your report generator you use Access Form/Report functionality. ... >Technet Script Center for some automation techiques on gathering your ... I am assuming it would be via an Access database, ...
    (microsoft.public.visio)
  • Re: Which Version of Visio is this? - Access Database from Visio
    ... "Generating an Access database from a Visio database diagram" which explains ... How to convert Database Model Diagram in Visio 2000 Enterprise to a Microsoft ...
    (microsoft.public.visio)
  • RE: database model diagrams and notes
    ... database but you can't print off the schema. ... There is a version of Visio called Visio for Enterprise Architects, ... The database solution in 'VEA' included additional reports. ... I've added notes to entities and columns within a DB diagram but how do you ...
    (microsoft.public.visio)
  • Forward Engineer a Database
    ... I have Visio 2003 for Enterprise Architects sp3 installed on my machine. ... reverse engineered a SQL 2005 database into an "ER Source Model" diagram. ... it says my version of Visio can't forward engineer a database at all!?!? ...
    (microsoft.public.visio.general)
  • Re: Maintaing Shape Data
    ... Visio was one of the first products to include native visual basic for applications. ... Shapes don't link directly to the extenal data. ... On this Diagram we've linked data from an Access database> to ...
    (microsoft.public.visio)
Loading