
Field properties bug in Jet.OLEDB provider SP5
I think I've found a bug in the SP5 (4.00.4331.4) provider; it's no
longer possible to determine whether a column allows nulls from the
field properties. My apps use this information as visual feedback to
show mandatory fields and it suddenly stopped working after the
upgrade.
This has been possible since the Jet 4.0 provider was issue and works
correctly in both SP3 (4.00.2927.2) and SP4 (4.00.3714.0). It's
definitely the provider as if I substitute back the SP4 version it
works again.
Hope this helps someone else from tearing their hair out :-)
Regards
Paul Hatcher, MCSD
Principal Consultant
Graduate Associates Ltd