Programmatically Change Column's Numeric Scale

[JohnJohn]

Hello.

Can someone show me the proper syntax to change the "Scale" property on a
column, preferably using ALTER COLUMN syntax?

Right now, the column is defined as Decimal with a precision of 8 and Scale
of 0. I want to change the Scale value to 4.

Thanks very much!
John

 

[Allen Browne]

Try:
CurrentProject.Connection.Execute "ALTER TABLE MyTable ALTER COLUMN
MyDecimal DECIMAL(8,4);"

You're a brave man trusting this data type in JET though.