Why MS Access adodb in .NET returns 34 in fieldcount when table has 42 fields ?

Question

Why MS Access adodb in .NET returns 34 in fieldcount when table has 42 fields ? I see 42 fields in table of my MS Access mdb database. But ADODB layer in .NET sees only 34 fields. The Outofrange exception occures when I am calling method getOrdinal("FieldName") of reader class.

Is it something I am missing in setting up connection, license or anything?

Thank you

Answer 1

Have you changed the table since you wrote the code? Sometimes you have to relink the tables inside Access, or it won't see the new columns.