Error to Generate MS-Access database from Database Designer

Hello,
I was trying to generate an MS-Access database from Database Designer. I got following error log :

3/9/1997 15:31:15: +++ Initialising database connection for reverse engineering
3/9/1997 15:31:17: ODD-15031 ODBC Connect: Error detected - k:\\cds\\cdsr\\genconn.cpp.485
CREATE TABLE Order_Details (Order_ID INTEGER, Product_ID INTEGER, Unit_Price NUMERIC(18,4), Quantity SMALLINT, Discount REAL) : -1; ,Native:-3551,Origin:State:37000[Microsoft][ODBC Microsoft Access 2.0 Driver]
 error 'Syntax error in CREATE TABLE statement. '
3/9/1997 15:31:17: ODD-11007 DDL exec: execution error - line 6 CREATE TABLE Order_Details (Order_ID INTEGER, Product_ID INTEGER, Unit_Price NUMERIC(18,4), Quantity SMALLINT, Discount REAL) error

Any idea why the error is produced?

I also tried to do reverse engineering of an existing MS-Access database . The tables were imported without the Primary Keys. I suppose because the ODBC driver I have is not second level complaint.

Any idead if a second level complaint driver exists for MS-Access database (16 bits)?

Thanks,

        Mishael Porat. Received on Wed Sep 03 1997 - 00:00:00 CEST