I wrote an VB application, which works with an Access 97 database via ADO
2.0 on an NT 4.0 machine. Using the 3.51 OLEDB provider the application
works without problems. When I replace the 3.51 provider with 4.0, the
follow problem occures:

With provider 3.51 textfields are returned as "adVarChar". Now with provider
4.0 these textfields are returned as "adVarWChar". This causes some problems
in my application.

Is it possible to make a special setting on the 4.0 provider, that the
textfields will be returned as "adVarChar"?

Orlando

I'm having the same problem. Problem occurs when updating fields with an
empty string.

A quick workaround is...

rs.field("fld").Value = strVar & vbNullString

This seems to work most of the time.

Please let me know if you find anything else on this subject. I hate
workarounds.

Paul