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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

  • Visio Diagram - Create Architectural drawings with visual effects & themes
    ... There is some information about Database in Visio at the Visio Toolbox website. ... Visio 2003 Database Link to Diagram ... If pAdoDbRecords Is Nothing Then ...
    (microsoft.public.visio.developer.vba)
  • 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)