Increase field size from code

[Charles Tam]

I would like to write code (in Access 97) to increase field size of an Access
97 table.

Does anyone know how?

 

[Ofer]

Use Alter table, look at this link

http://office.microsoft.com/en-us/assistance/HP010322071033.aspx

 

[Charles Tam]

However, Access 97 does not seem to support "ALTER COLUMN field
type[(size)]". Any other options?