Change MS Access text field size

[PedroA]

Hi,

Is there a way to change the size of a 2003 MS Access database text field using VB.Net?

Thanks

 

[jmcilhinney]

ALTER TABLE Statement - Access

Like any other SQL statement that doesn't produce a result set, you would execute an ALTER TABLE statement by calling ExecuteNonQuery on an OleDbCommand.

 

[PedroA]

Yes, thanks. Got it working