Change field type from VB

[Ana]

Hello,
I have an Access database with a table containing a decimal field wich has
these properties:
precision: 18
scale: 5
decimal places: 5

I need to change this to:
precision: 28
scale: 13
decimal places: Auto

Do any of you know how can I change this by executing a query similar to
ALTER TABLE Table1 ALTER COLUMN Field1 DECIMAL...

Thank you. Regards,
Ana

 

[Allen Browne]

Try:
strSql = "ALTER TABLE Table1 ALTER COLUMN Field1 DECIMAL(28,13);"
CurrentProject.Connection.Execute strSql

Presumably you are aware of the problems JET has in handling the Decimal
data type:
http://allenbrowne.com/bug-08.html