Using PowerDesigner to build an Access database

PowerDesigner Generating an Access database

Since the use of PD has been known to support access but has not figured out how to create Access data tables from scripts. Finally, the answers found in the PD tools are in the C:\Program files\sybase\powerdesigner 12\tools directory. Currently, only access97 and access2000 databases are supported. ACCESS2007 database is not supported, but no matter, as long as the generation of access2000 database upgrade on the line, but the trouble is to get a access2000 environment. Of course, the direct use of access20007 is also possible, but it is necessary to use the 97 version of the line, opened after the macro enabled is OK. Otherwise it won't work.

The principle of creation is that a program written by Access parses the script that executes the PD generation and ultimately creates the data table in the data file.

It is important to note that if you use the Tools directory to generate Acccess.mdb, you need to change the database in PDM to ACCESS97. If you use Access2k.mdb to generate, you need to change the database to acccess2000.

If a "type mismatch" occurs during the build process may be a problem with some default settings, or if the field is set too long as varchar (500), access can only be 255.

View the Tools.txt file to understand. The original text reads as follows:

This file contains informations about contents of. \tools subdirectory under PowerDesigner installation directory.

MS Access Reverse (access. MDB and ACCESS2K. MDB)
===============================================

Data exchange between PowerDesigner and Microsoft Access (and) works with. DAT files. These files is created from PDM files via script generation, and reversed into the PDM. The Access.mdb (Microsoft Access Access2k.mdb) and (Microsoft Access2000) databases use or create these files to genera Te or reverse Access databases.

Opening the appropriate database opens a window in which you configure the database generation or reverse engineering.

Ex.

Examples:
to reverse Engineer Microsoft Access the database "C:\temp\MyDB.mdb" in a powerdesigner physical Data Model :
1. Double-click <powerdesigner_directory>\tools\access.mdb
2. select  "Reverse engineer Access Database to PowerDesigner script"
3. type  "C:\temp\MyDB.mdb" in select Database (or click the Search button)
4. Type the . DAT file to create in PowerDesigner file
5. Click on Create
6. Select dbms->reverse Engineering Databases in the PowerDesigner PDM window
7. Select the newly generated file as script file to is reversed
8. Click OK

To generate a Microsoft Access the database from a powerdesigner 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

Note for V6 Users:you can isn't use the old Genacc.bas file with PowerDesigner.

The following on the Internet do not know which guy translated. I made the adjustment:

To generate an Access database from an existing PDM (database physical model) file, first create an empty access data file, Blank.mdb, and then generate an Access database script, such as Cre_database.sql or cre_ Database.dat (typically SQL)

Build a Microsoft Access database
PowerDesigner and MS (Microsoft) Access databases Exchange information between. dat files, which are created from a PDM (physical model) file through script generation, and Access's. mdb database creates a database using a. dat file or generates an Access database inversion operation. DA T file.

Here's how to generate an MS Access database from a powerdesigner PDM file:
1. Generate database script files in PowerDesigner
2. Double-click the Access.mdb in the Tools directory under the PowerDesigner installation directory (this is access97, if access2000 please select File access2k.mdb) file (to open this file, you need to install access, check if your access has After successful installation.)
3, open after successful will have a radio box to select, select the first item "Create an Access database from a PowerDesigner script file"
4. Then select the empty Access data file with the PD generated script in the two box below. Enter the target database in the Select Database box or click Browse to select the target database (that is, the previously created Blank.mdb file)
5. Enter the script file created by PowerDesigner in the "PowerDesigner file" or click Browse to select the script file (if the file is not found, select all files in the file type)
6. Click the "Create" button.

Http://www.cnblogs.com/liubiqu/archive/2009/07/16/1524542.html

Using PowerDesigner to build an Access database