changing multiple fields type to double

[neefbeef]

hey,

i got large database (mdb) and i need to change all number field type from long interger to double.
thanks in advance.

[June7]

Try an ALTER TABLE action: http://www.w3schools.com/sql/sql_alter.asp

Automation to modify every number field for every table will require some elaborate VBA.