Field properties bug in Jet.OLEDB provider SP5 
Author Message
 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



Thu, 29 Jan 2004 01:25:00 GMT  
 Field properties bug in Jet.OLEDB provider SP5
I have found that the IndexNulls property returns garbage with
VB6/SP5/NT4/SP5/SQL Server 7.0 (SQLOLEDB) with MDAC 2.5 (and ADOX 2.5) as
well.

Regards,
Tore.


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



Sat, 31 Jan 2004 07:24:48 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How to set Format property in ACCESS2k thru ADOX using JET OLEDB 4.0 provider

2. Replace OLEDB provider Jet 3.51 with Jet 4.0

3. Microsoft.Jet.OLEDB.3.51 provider not registered

4. Microsoft Jet OLEDB Provider 3.51: Does it support parameterized querys

5. Problem using OLEDB provider for Jet 3.51

6. Jet OLEDB provider: Valid wildcard SELECT returns nothing in ASP

7. Microsoft.Jet.OLEDB.4.0 OLE DB provider

8. Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider

9. Jet OLEDB.4.0 and MSDataShape Providers

10. Jet.oledb provider with Access 97

11. How to install Provider (MS.Jet.OLEDB) with Setup

12. Provider=Microsoft.Jet.OLEDB.4.0 vs 3.51

 

 
Powered by phpBB® Forum Software