Table (1 Viewer)

[Assad]

hello i have written this kind of query in access 365 and am still getting the error "syntax in CREATE TABLE statement" what could be the problem

 

[arnelgp]

why not create the table in table designer not on DDE sql.
varchar is for MSSQL server only.

use:

Create Table Course (
c_id Text(4) Primary Key,
title Text(20),
dept_name Text(20),
credits Integer)

 

[Edgar_]

varchar is for MSSQL server only

Access can handle varchar...

Agree with the rest...

 

[arnelgp]

..so the error is in numeric(2,0)

you can use double or integer

 

[arnelgp]

Access can handle varcha

yes it did on my test, did you test the rest?

 

[Edgar_]

yes it did on my test, did you test the rest?

No, but I recall having problems with other data types when using CREATE TABLE, decimal being one of them

 

[arnelgp]

CREATE TABLE, decimal being one of them

researching..
you can use ADO to create it:

CurrentProject.Connection.Execute "Create Table X_Table (DecField Decimal(18, 2))"

 

[Edgar_]

CurrentProject.Connection.Execute "Create Table X_Table (DecField Decimal(18, 2))"

You legend, thanks for the tip

 

[Assad]

i tried deleting the default table when opening access at the first time, and then i run my queries it worked, but what i can't understand is that the same format of queries i used to create another table, it failed! so i still can't put the finger on what access wants when creating a table.

 

[Pat Hartman]

There are reasons for creating tables using DDL. Based on your last response, I'm guessing that this is not one of them. Temp tables just cause bloat. There are other solutions.