How Do I create a MS Access database from a PowerDesigner 7.5 generated script?

[stefan...@pdb4.siemens.de]

I dont know how to create a new MS Access 95/97 database from scratch using
the PD7.5 generated .sql script.
The 'usage' information presented after the script generation is quiet
confusing, cause I don't know the features neither in MS Access nor in
PD7.5.

I did the same with PD6.x and the generated script was VB-Code and
everything was fine.

Thank's, Stefan

[Lukas Koster]

Hi,

I had the same problem last week. But I finally worked it out.
In the PowerDesigner directory (the directory where PD is installed) go to
the Tools subdirectory. There you see two MS-Access databases: Access.mdb
(for Access 95/97) and Acces2k.mdb (for Access 2000). For 95/97 just open
the Access.mdb (double click or whatever you want); then a macro (I think)
is automatically started prompting you for the new database-name and the
script you just generated. Then hit the button "create database" (or
something like that). The generated script file is used by this macro to
generate a new MS-Acces database. You might want to check out the generated
datatypes. I had to change the datatype translation definitions in the
Object Language I use (OOM - Java). Maybe just using PDM will work out fine.

Good luck!
--
Lukas Koster
NIWI
Dept. IT/I
Email: Lukas....@niwi.knaw.nl

<stefan...@pdb4.siemens.de> wrote in message
news:AC3DE87170FEA6F0003ACE0F852569B6.003ACE1F852569B6@webforums...

[Anthony Hill]

Information on generating and reverse engineering MS Access databases
is found in the "Tools.txt" file which is located in the tools
sub-directory. The following is an excerpt from the file:

To generate a Microsoft Access 97 database from a PowerDesigner 7 PDM:
1. Generate Script file from PowerDesigner PDM (the usual procedure)
2. Double-Click the file <PowerDesigner_Directory>\Tools\access.mdb
3. Select "Generate Access database from PowerDesigner Script file"
4. Type the destination database in Select Database (or click the
Search button)
5. Type the file created by PowerDesigner in PowerDesigner File
6. Click on Create

Anthony Hill
PowerDesigner Product Support

On Fri, 15 Dec 2000 05:42:18 -0500, stefan...@pdb4.siemens.de
wrote: