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: 580
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
