VB Error 14

I had similar errors working with VB and a SQL DB. I updated the VB and it fixed the errors.

It may work for you. My workstations were 95/98 and SQL ran on an NT4.0 box.

Error 14 is 'Out of string space'
Windows dynamically allocate memory for string storage. When a very large string or string array is created, eventually there's not enough room. It probably happens occaisionally when a big chunk of data is read from SQL.

The following code will cause this error:

MyString = "Hello"
For Count = 1 To 100
MyString = MyString & MyString
Next Count

Here's a link to an MSDN article about it:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamsgoutofstrspace.asp

(make sure there are no spaces in the URL)