Working with TableDefs

[farssr]

Periodic upgrading of a database occasionally requires changing a field's datatype. I want to do this while preserving table content. Can I change field size with coding like this?



Set tdfMyTable = dbsData.TableDefs!tblMyTable
fld.Type dbLong
tdfMyTable.Fields.Refresh

The second statement gives an invalid operation error message.
Any ideas? Thanks.

[farssr]

I used the dbs.Execute command to run an ALTER TABLE statement that ALTERs the column type.

[ajetrumpet]

solved, marked.