Cannot change scale of number?

[idiot]

CREATE TABLE tblDecimalDataTypes (
DefaultType DECIMAL,
SpecificType DECIMAL(10,5))

I executed the SQL statement above in access 2003 and I got the syntax
error.

 

[Allen Browne]

I do not think JET understands the statement you used.

Try:
Dim strSql As String
strSql = "CREATE TABLE tblDecimalDataTypes (Field1 DECIMAL (10,5));"
CurrentProject.Connection.Execute strSql

Presumably you are aware that JET cannot be trusted with even very basic
queries using this data type:
http://allenbrowne.com/bug-08.html