Record set out of string space

[ckseng11]

Hi everyone,
I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening

KOKSENG

 

[Bob Barrows [MVP]]

Hi everyone,
I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening

KOKSENG

Without seeing any code, or being given any idea of the kind of activity
that lead to this error, all I can do is point you to these:
http://www.google.com/search?hl=en&lr=&q=recordset+"out+of+string+space"&btnG=Search
and
http://groups.google.com/groups?hl=en&lr=&q=recordset "out of string space"&btnG=Search&sa=N&tab=wg

Please read through all the search results to see if any of them help with
your problem. If not, post back with more information.

 

[Patrice]

IMO likely too much string manipulations (for example concatenations).