jet engine not updating long strings in access

[rrazvan]

Hello,


has any of you seen situations, where only a part of the text string is updated in an access database ?

I am sending SQL update requests to an access database using a jet engine from VB. The same variable that I am using to update the access database works just fine when updating a LDAP database.

Thank you,

Razvan

 

[Travis]

What is the Defined length of the Access Field?

What is the Length of the Variable (String that is)?


What is happening is that the data is being truncated because not all of it will fit in the Access Field. The wrong data type being used is the primary reason for this occurring.