Change field type from VB

[Guest]

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

 

[Jamie Collins]

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

Presumably you are aware I have refuted a number of your claims on many
occasions in the hope you will review the article on your site and
correct some of the inaccuracies. For example, "Nulls and zeros sort
unpredictably - at the beginning, middle or end, depending on the
data." Can you provide a reproducible example where Jet 4.0 sorts null
values (for a column of any type) to anywhere other than the end of the
resultset?

Jamie.

--