I'm having trouble extracting data from an Access Memo field using a Microsoft Remote Data Control. I'm using VB6. All the examples show something like:
Dim Buffer() As Byte
Buffer() = Rs!Myfield.GetChunk(dataSize)
For me this raises the error 'invalid use of null' since this is what Rs!Myfield.GetChunk(dataSize) is always returning.
Testing using a short memo both Rs!Myfield.ColumnSize and Rs!Myfield.Value are correct in the watch window - Rs!Myfield.ChuckRequired = true. (Aside: assigning Rs!Myfield.Value directly to a string raises the error 07001 'incorrect number of parameters')
What am I doing wrong?