How to determine MS Access field size via OleDb

Posted by Andy on Stack Overflow See other posts from Stack Overflow or by Andy
Published on 2008-10-11T18:05:51Z Indexed on 2010/03/13 15:45 UTC
Read the original article Hit count: 544

Filed under:
|
|
|

The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method.

I need to change a field width. The ALTER TABLE statement is working fine. But I would like to avoid executing the ALTER TABLE statement if the field is already the appropriate size. Is there a way to determine the size of an MS Access field using the same OleDb connection?

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about jet