Not enough storage is available to complete this operation

[Suttema]

Hi I've a problem with reading data from Access Database. If I want analyse a product these datas over 6 month for example, I became the error message "Not enough storage is available to complete this operation"

 The codeline who makes this error is

"aValues=RecordSet.GetRows(-1,0,aColumnNames)"

I've 1GB RAM on my PC but i tried it also on PC with 2GB RAM it doesn't help. 

Is this a Problem with the MDAC from Microsoft? I'm working with Win XP SP3 and MDAC 2.81 SP1.

 I have no more idea wa could be the reason...

Have someone a idea or the same Problem?

best regards

[Brad_Turpin · Accepted solution]

Hi Suttema,

I'd like you to try a buffered recordset request, instead of asking for all the records at once.  See if this example helps.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Suttema]

Thanks I've tried the example code and it works, now I'm implementing the code into my programm....