Use powerdesigner
First of all, you shoshould configure your ODBC to connect your access. second, reverse database from ODBC by powerdesigner. from menu, select database-> reverse engineer database, then select ODBC you configured just now. last, click OK to re-generate PDM from your access.
By the way, if you want to generate access to other source database, like SQL Server, Sybase ASE or oricle, you can select database --
> Select current DBMS. After that, you can generate DML, DDL from PDM.
Create an ODBC Data Source
Knowledge of ODBC and BDE data sources and their creationCubeMethod
ApplicationProgramThere are multiple methods to access databases, such as using ODBC and ADO. All instances in this book are accessed through ODBC and BDE. The following describes how to establish an ODBC data source connection. (1) Go to the Windows Control Panel, find the [Data Source (ODBC)] option in the control panel, and double-click to enter the [ODBC data source Manager] dialog box, as shown in 1. If no
The supervisor can find the executable file named "“odbcad32.exe" in the Windows directory and run it.
Figure 1 ODBC data source Manager (2) Select the system DSN tab and click Add to create a new data source form. Select SQL Server, as shown in figure 2.
Figure 2 create a new data source 3) Click Finish. A Data Source Parameter Setting form is displayed. enter the name of the data source and the name of the server to which the data source points. In this example, jxclink and ". ", 3, Service
"." Indicates that the server is a local computer.
Figure 3 set data source parameters 4) Click Next. The Security Authentication form is displayed. Set the user name and password for accessing the database, and click Next. Select database form, as shown in figure 4. Select [more
Change the default database to check box and change the connected database to the database we created earlier.
Figure 4 select database 5) Click Next and a confirmation form is displayed, as shown in Figure 5. Click test data source to test whether the new data source can be connected. Click Finish.
Create an ODBC data source.
Figure 5 The following describes how to establish a BDE data source connection on the form. Go to BDE administrator and click the object | new menu command. The new databasealias dialog box is displayed, as shown in 6. Select "SQL Server" and click OK to name the data source.
Change the name to "jxclink", and set the odbc dns attribute to "jxclink. Figure 6 selecting the BDE Data Source Type Note: UseCode, You must manually establish the corresponding ODBC and BDE data source connection.